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 ?
Thanks
#nK
Hey @fairymemay
Expect the ToString
at the end everything looks proper.
Kindly check the case of it & update.
Try this may be helps.
Thanks
#nK
Let me check the workflow attached please…
#nK
@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.
row2.Item(“App”).tostring.Contains(row1.item(“App”).tostring)
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 .
Thanks
#nK
Hey @fairymemay
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…
Thanks
#nK
Good guess. Will see
@Nithinkrishna @kirankumar.mahanthi1 I have more question.
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
Thanks
#nK
@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.
Please guide me for solve it.
input (4).xlsx (15.1 KB)
map data.xlsx (9.0 KB)
Hey @fairymemay
Kindly find the sample demo for the test excels provided…
nmnithinkrishna_MapExcelData.zip (19.6 KB)
Hope this helps
Thanks
#nK