Articles → UIPATH → Generate Data Table Activity In Uipath
Generate Data Table Activity In Uipath
Purpose
Example
Click to Enlarge
- Drag and drop the "Read Text File" activity to read the data. Set the output to the "Result" variables.
Click to Enlarge
- Drag and drop the "Generate Data Table" and set the following properties.
- Set CSVParsing to False.
- Set NewLineSeparator to Environment.NewLine
- Set Input field to Result
- Set DataTable field to "DT1"
- Check the "UseColumnHeader" option
Click to Enlarge
- Now click on the "Generate Data Table…" button.
- A pop up window will appear. In the window, perform the following steps.
- Check the checkbox "Use First Row as Column Headers".
- Set "Column Separators" as "[Space]".
- Set "Newline Separator" as "[newline]".
Click to Enlarge
- Click on the "Ok" button to close the popup window.
- Drag and drop the "For Each Row" activity and loop through all the rows in the data table.
Click to Enlarge
- Save and run the bot.
Output
Click to Enlarge