Condition in if error?

I want to compare 2 datatable in condition as below.

But show error , Please guide me for solve it.

1 Like

Is your project built on c# or VB ?

Thanks
#nK

@Nithinkrishna VB

1 Like

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

@Nithinkrishna error.

Main.xaml (13.8 KB)

1 Like

Let me check the workflow attached please…

#nK

1 Like

@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)

1 Like

@kirankumar.mahanthi1 error as below.

1 Like

Hey @kirankumar.mahanthi1

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

1 Like

Got it @Nithinkrishna

1 Like

Good guess. Will see

1 Like

For me perfectly working fine. please check the suggestion from Nitin @Nithinkrishna

2 Likes

Cool @kirankumar.mahanthi1

Very thanks for that prompt help.

@fairymemay, Kindly check please…

Thanks
#nK

2 Likes

@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.

1 Like

Sorry I don’t understand it

Kindly explain more

Thanks
#nK

@Nithinkrishna I have file input as below.
image

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)

1 Like

@Nithinkrishna remark : in real file map data have 100,000 records (rows)

1 Like

Hey @fairymemay

Kindly find the sample demo for the test excels provided…

nmnithinkrishna_MapExcelData.zip (19.6 KB)

Hope this helps

Thanks
#nK

1 Like