Hi UiPath Devs!
I am doing the same thing as has been described in a post from one year ago and I really need to modify the column types because when I use AutoDetect Types it basically corrupts the data by stripping away leading zeros.
I have through extensive google-ing found out that the most recommended solution seems to be to:
- Generate datatable A
- Clone to a new datatable B
- Modify columns in datatable B (empty schema) as needed
- Loop through and add rows from A to B
This is probably fine for relatively small amount of data but adds a considerable time penalty to the processing when the data gets bigger.
Is there any plan to extend the Generate Data Table activity in such a way that the data types can be set (schema defined) instead of relying on the AutoDetect - or skipping AutoDetect and relying on the procedure here above?
This is one of the VB sources that complemented this approach…