14-08-24 01:55 AM
Hello to all
I have a scenario.....
1, Compare 2 excel files, Main file contains 10 columns and comparison excel contain 20 column
2.both excel column not same order
3.Both excel rows also different count
4. Main excel file 10 column is available in comparison excel.
5, I need to compare these 2 files and find out the difference only in 10 column of the excel then take that difference as an output copy into excel.
Please anyone did before and share your thoughts
Regards.
SabithaNirmal
19-08-24 01:32 AM
19-08-24 01:33 AM
19-08-24 01:35 AM
19-08-24 09:13 PM - edited 19-08-24 09:13 PM
Without a code stage it will be difficult
We need to :
1- Remove some columns from the comparison excel file (native bp function)
2-put the comparison excel file columns with the same orders of main excel file columns (code stage)
3- Create a unique key column for the main excel file and the comparision excel file (code stage)
4- Filtering (native bp function)
So if you are ok with this i can give you the process to do your task step by step with screen shot
Regards
20-08-24 01:46 AM
20-08-24 12:48 PM
i think i might not have been clear, the actions i was mentioning would be done in blueprism. You would use actions in the vbo to write the formula to the desired cell and you can use the vbo to drag the formula down to the desired number of rows as well.
20-08-24 04:27 PM
Try my colleague @michaeloneil solution
If it's still not working we can make a call on teams m.dakkouri@infinityco.fr
Regards