Condition in if error?

@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

@Nithinkrishna How to loop read all sheet in file input?

1 Like

Hey @fairymemay

Use Get Sheets activity & store the sheets collecton.

Then Iterate the collection using For-each

Hope this helps.

Thanks
#nK

@Nithinkrishna I edit your code for loop sheet as below.

Main.xaml (23.1 KB)

But now show error , I don’t know what wrong?

and I have question , If data 100K , it run slow or not.

1 Like

Kindly correct the Address2 spelling in the input sheet.

For the data count you mentioned, is it input sheet data or the other sheet…?

Hopefully that shouldn’t be an issue…

Thanks
#nK

1 Like

@Nithinkrishna Now , It can run.
But I think run slow , because use for each row (data have 100K ----> slow)

How to another way for map data fast?

1 Like

Hey @fairymemay

It’s possible through LINQ

Thanks
#nK

@Nithinkrishna Can​ u​ guide​ me​ for​ use​ Linq?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.