Now I use activity Add data row, but it run long time (because data have 30k)
Please guide me for solve it.
Now I use activity Add data row, but it run long time (because data have 30k)
Please guide me for solve it.
Hey @fairymemay
No need of the last for-each you have used to do Add data row
You can directly copy that data table or merge it with your final DT
Hope this helps
Thanks
#nK
@Nithinkrishna I don’t understand.
Hey @fairymemay
Just use the copy to datatable statement directly in an assign instead of using it in foreach source.
Thanks
#nK
@Nithinkrishna If I shared your flow with you for recommend this case.
Are u okay?
Yes please…
Thanks
#nK
@Nithinkrishna My flow as below.
Sep Sheet.xaml (181.8 KB)
Hey @fairymemay
Are you writing all the columns from the RowArray
to the OutputDT
or only specific columns ?
Thanks
#nK
@Nithinkrishna only specific columns ?
Config_SepSheet.xlsx (13.8 KB)
Hey @fairymemay
Currently I’m assuming you are copying all the columns, So here it is
Hope this helps
Thanks
#nK
All the columns mentioned here ?
@Nithinkrishna Almost column from file config add to outputDT
@Nithinkrishna Any Update about flow?
Hey @fairymemay
Sorry for late response. Please find the below.
Attaching the workflow as well,
nmnithinkrishna_CopySpecificColumnsFromDT.zip (13.7 KB)
Hope this helps.
Thanks
#nK
@Nithinkrishna I can’t understand how to apply in my code?
The place which you have shown already in the screenshot, that is the place you will need to replace with this please…
Thanks
#nK
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.