I have a process that require to join to datatables.
As an Input i have extract from different systems data in excel
When i use read range activity - an error occure that column names are not unique.
How to avoid this and keep headers in place as then i will need to join tables and needed columns for joining can’t be specified by index, only by name.
How i see a solution:
- read first row
- put it in a variable
- check if there duplicated values
- modify such values by adding 1,2,3 etc (like pivot table in excel)
- read whole range with modified headers
Unfortunately i can’t implement this as i still very new in UiPath
Can you help me with this issue?