How to compare the Excel?

if I’m having the name Traffic Headers Traffic Headers.xlsx (9.3 KB)

Excel 2 as having a Headers as Default Channel grouping column and take a (Others) column value add with Email column, and write a value in Email row and then i need to compare the two excel, if the value matches means write the sessions value from Excel 2 in Traffic Header Excel appropriate Headers if not match means make the value as “-” in Traffic Header Excel.

Excel 2:Excel 2.xlsx (4.6 KB)

Can any one please help…

Thanks in Advance

Simple way is you can use two for each row logic or if you are known about linq you can use that.

1 Like

Not yet find the solution…
could you please provide a flow

Thank in Advance

@palanikumar could you please provide a linkq query for this scenario