Compare collections/excel to get

[Makus]

Hello,

Can somebody help me write a Blue Prism Code or Excel Macro that will solve the problem below?

I have two collection in input with same columns, I need to compared it. When Bot find difference - markt it.

Using Loop and collections manipulations is too long for me..

Input: Source. Target
Output: Compared when find difference set value like this: Source Value/Target Value
View attachment 2.jpg

 

[Sachin_Kharmale]

Hi Makus,

So your both table have same number of rows and same no of columns?
both table have same column names only table contains diff data ?

 

[Sachin_Kharmale]

If yes then follow the bellow Approach:
1- Take two Collections in blue prism Source collection and Target Collection.
View attachment 1575532007738.png

View attachment 1575532024525.png
2- Write bellow code in code stage.

View attachment 1575532063046.png

3. After execution of code stage you will get output as per you requirement.

View attachment Combined Collection Output.JPGull]4900[/ATTACH]

i hope it will help you ..!

 

[Makus]

Thank you very much

In my collections the number of columns is the same, but they differ in the number of rows