@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 .
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
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.
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
@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?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.