How to compare data in 2 different excel based on condition and add copy respective data and add to main excel

Help Activities
, ,
1

Hi ,
Need help in comparing data in excel , tried with lookup data table but , not gettign expected op.
pls help.

RefFile- Just to used as a reference and changes in file not required.
need this file to get the output in InOp file

InOp file - 1st sheet is ref data , and it will be in orch can be accessed curretrow(colName)
Col B and C in red is expected output

need to check sheet name ,- if it’s 11 then check DataInOrch Sheet and check for CL and MT, then goto RefFile and gpply filter to get
CL and MT and then check DT value in InOp file and DT value of RefFile, if macthes then copy wrod1 and word2 in InOp file’s B and C column
which is in red as of now…you can add in D and E column

InOp.xlsx (14.2 KB)
RefFile.xlsx (18.5 KB)

2

@8b6861dc5e0c9f7008548ca66

can you please clarify few things

this line contradicts with below

do we need to modify ref file or no/?

when there are same combinations how do we resolve?

image

cheers

3

@Anil_G Thanks for reply !
np., ref sheet no need to modify …
red in io file is sample output required

4

@8b6861dc5e0c9f7008548ca66

Also can you answer the second piece …what to do with similar rows in ref file?

cheers

5

@Anil_G , we need to consider 1st match only , and in 2nd time consider 2nd match

6

@8b6861dc5e0c9f7008548ca66

then is the output provided wrong?

image

it has both in it

cheers

7

for DT value Ent we can treat it as a sequence and can put seq match from ref , if there are no equivalent no of matches then by default put 1st match word 1 and word 2
Ent 1
Ent 2
Ent 3
Ent 4
Ent
Ent
Ent

actually even , req provider is confused :frowning: but , no choice

8

@8b6861dc5e0c9f7008548ca66

unzip the package and run the sequence.xaml on your system…you should see the output as expected

image
image696×701 29.8 KB

image
image691×717 31.6 KB

image
image688×720 31.1 KB

image
image693×672 19.3 KB

BlankProcess - Copy (17).zip (32.4 KB)

Hope this Helps

cheers

1 Like
9

Thank you it is working @Anil_G

10

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