Compare 2 Excel data

Get Help & Discuss Process Studio
1

Hello All,

I am having 2 excel
1st excel header - a,b,c,d,e,f
2nd excel header - a1,d1,e1,f1

I want to achieve following steps

At first it has to take 1st row of 1st Excel and compare with all rows of 2nd excel.
if a=a1 & b=b1 & c=c1.
Then complete row of 1st has to be saved in 3rd excel.
break
else
Then complete row of 1st has to be saved in 4rd excel.

Please let me know how to do this

Regards,
Ramesh

2

Hello

Using stream lookup and filter you can achieve this.

Steps

  1. Read 1st and 2nd Excel using Excel Input
  2. Take Stream lookup map the colunm i.e keys to Lookup values ( a=a1,b=b1, so on). and select any one column from Lookup sheet(Excel 2).
  3. Output of stream lookup :value of selected column will be null if row in 1st Excel is not present if 2nd Excel.
  4. Now use row filter i.e if Selected column is Not Null the write it to Excel 3 otherwise to Excel 4.