cancel
Showing results for 
Search instead for 
Did you mean: 

excel comparison

SabithaNirmal
Level 3

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

16 REPLIES 16

Hi @Mohamad_747 

Yes, your understanding is correct.

 

Hi @michaeloneil ,

Thanks for your suggestion but this one i want to perform with blue prism only

 

 

 

Hi @Mohamad_747 ,

I want to preform without using any code and with using multiple VBO's

 

Hi @SabithaNirmal 

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 

Hi @Mohamad_747 ,

I can compare two different excel by following way. please see below

11.png

 

hi @SabithaNirmal 

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.

@SabithaNirmal 

Try my colleague @michaeloneil  solution 

If it's still not working we can make a call on teams m.dakkouri@infinityco.fr

Regards