Articles → UIPATH → Generate Data Table Activity In Uipath

Generate Data Table Activity In Uipath

Purpose

Example

1. Drag and drop the "Read Text File" activity to read the data. Set the output to the "Result" variables.


Click to Enlarge


2. Drag and drop the "Generate Data Table" and set the following properties.
   1. Set CSVParsing to False.
   2. Set NewLineSeparator to Environment.NewLine
   3. Set Input field to Result
   4. Set DataTable field to "DT1"
   5. Check the "UseColumnHeader" option


Click to Enlarge


3. Now click on the "Generate Data Table…" button.
4. A pop up window will appear. In the window, perform the following steps.
   1. Check the checkbox "Use First Row as Column Headers".
   2. Set "Column Separators" as "[Space]".
   3. Set "Newline Separator" as "[newline]".


Click to Enlarge


5. Click on the "Ok" button to close the popup window.
6. Drag and drop the "For Each Row" activity and loop through all the rows in the data table.


Click to Enlarge


7. Save and run the bot.

Output