Need help in comparing data in excel , tried with lookup data table but , not gettign expected op.
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)
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?
@Anil_G Thanks for reply !
np., ref sheet no need to modify …
red in io file is sample output required
Also can you answer the second piece …what to do with similar rows in ref file?
@Anil_G , we need to consider 1st match only , and in 2nd time consider 2nd match
then is the output provided wrong?
it has both in it
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
actually even , req provider is confused but , no choice
unzip the package and run the sequence.xaml on your system…you should see the output as expected
BlankProcess - Copy (17).zip (32.4 KB)
Hope this Helps
Thank you it is working @Anil_G
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.