I want to compare 2 datatable in condition as below.
But show error , Please guide me for solve it.
Is your project built on c# or VB ?
ToString at the end everything looks proper.
Kindly check the case of it & update.
Try this may be helps.
Let me check the workflow attached please…
@Nithinkrishna My file that I use in my flow.
File map data :
map data.xlsx (9.0 KB)
File input :
input (3).xlsx (15.1 KB)
*red text —> write after match data
Hi @fairymemay ,
Could you pls try like below. Thanks.
@kirankumar.mahanthi1 error as below.
Looks like this has been already tried but still error persists.
Could you please check that xaml if possible.
As it will take a bit more time for me to look into it .
I think you have created row1 and row2 as variables also.
If yes, Could you please delete those variables in the variables panel please…
Try this please…
Got it @Nithinkrishna
Good guess. Will see
For me perfectly working fine. please check the suggestion from Nitin @Nithinkrishna
Very thanks for that prompt help.
@fairymemay, Kindly check please…
If column App between file have found I want copy data for write in file input.
Please to guide me about it.
Sorry I don’t understand it
Kindly explain more
@Nithinkrishna I have file input as below.
I want match column App for all sheet except sheet output.
and have file for map data as below.
If value column APP in file input have found in Column APP in file Mapdata.
I want to copy data in column ADR1_2 , CLTADDR03 , CLTADDR04 , CLTADDR04 , CLTPCODE to column Address1 , Address2 , Address3 , Address4 , Address5 in file input.
@Nithinkrishna remark : in real file map data have 100,000 records (rows)