How to add data row fast?

Now I use activity Add data row, but it run long time (because data have 30k)

Please guide me for solve it.

1 Like

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.

1 Like

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?

1 Like

Yes please…

Thanks
#nK

@Nithinkrishna My flow as below.
Sep Sheet.xaml (181.8 KB)

1 Like

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)

1 Like

Hey @fairymemay

Currently I’m assuming you are copying all the columns, So here it is

nmnithinkrishna_seqtoreplaceforeach_uipath

Hope this helps

Thanks
#nK

All the columns mentioned here ?

@Nithinkrishna Almost column from file config add to outputDT

1 Like

Sure @fairymemay

I will be creating a demo flow for this and will share it with you.

Thanks
#nK

1 Like

@Nithinkrishna Any​ Update​ about​ flow?

1 Like

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?

1 Like

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.