Match two columns and enter value in third excel

Help
, ,
1

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)

2

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

3

Hi,

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

Sample20200116-1.zip (27.4 KB)

Regards,

4

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

5

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

6

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

7

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

8

@Soniya215
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

9

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

12

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

sample3
sample31595×715 27.3 KB

13

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

14

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

15

Thanks for the help :slightly_smiling_face:

16

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