Hello Experts,
I have a query and need your help.
In Screenshot we get data like this and bot need to analysis and insert new record.
Conditions-
- Bot should read one by one player Name and for each player it should check distinct names in blue color highlight column. If there is more than 1 people then it should search “X” in date range 1 jan to 7 jan in front of respective player name. If nothing found except “x” then nothing to do but if there is any value then “x” then bot need to insert same player as per how many distinct names found like there is 3 distinct name then same player should insert 3 times and in date range there should be some changes like in below screenshot. Please give me xaml file with using data tables, linq queries etc.
Output required like this below:-
Attaching dummy file for your reference. I want output as it shown in output required sheet.
Book1.xlsx (12.2 KB)
Looking for your help asap.