Match two columns and enter value in third excel

I have two excel sheets sample1 and sample2 containing a common column “numbers” and another column “Quantity1” and “Quantity2” respectively.I want to compare Quantity1 with Quantity2 and fill the status either value is less more or equal i.e. Q1>Q2 or Q1<Q2 or Q1=Q2 in excel sheet named sample3 which contains Numbers and status column.
Any answer would be of great help.
sample1.xlsx (8.2 KB) sample2.xlsx (8.2 KB) sample3.xlsx (8.2 KB)

Check this below workflow,
Sample_Sequence.xaml (17.4 KB)


There are many ways to achieve it. I’ll attach one of them as the following (using Join DataTable).
Hope this helps you. (27.4 KB)


Indeed, Many routes to the result: Soniya215.xaml (15.9 KB)

Thanks to all for concerning my problem. @ppr your solution best suited my workflow.
Thanks a lot to all

Perfect, that is running. So Lets Close the topic with flagging the solutio. for Open questions I am still reachable. Happy automation

@ppr If i am having decimal numbers in Quantity in place of Integers what should i change in the given workflow ?

Give a try on an alternate Conversion method: e.g CDbl. In case of it is not working, please post for us an example value. We have deep interest on any used characters of 1000 seperators, fraction sign

The CDbl works fine . If i have to add Quantity2 column next to Status column where do i assign that.

How to add Quantity2 value from sample2 sheet in this output sheet.

Thanks, i will Update the xaml and Share it with you. Just give me some time. Thanks

Have a look on the updated XAML:
Soniya215_V2.xaml (16.0 KB)

Thanks for the help :slightly_smiling_face:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.