Articles → UIPATH → Generate Data Table Activity In Uipath

Generate Data Table Activity In Uipath






Purpose





Example




Picture showing the unstructured data in the notepad
Click to Enlarge



  1. Drag and drop the "Read Text File" activity to read the data. Set the output to the "Result" variables
  2. Picture showing the Read Text File activity and assign the output to the Result variable.
    Click to Enlarge

  3. 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
  4. Picture showing the Generate Data Table activity and its properties window
    Click to Enlarge

  5. Now click on the "Generate Data Table…" button
  6. A popup 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]"
  7. Picture showing the Generate Data table wizard to preview the output data table
    Click to Enlarge

  8. Click on the "OK" button to close the popup window
  9. Drag and drop the "For Each Row" activity and loop through all the rows in the data table
  10. Picture showing the for each loop to loop through all the rows in the data table
    Click to Enlarge

  11. Save and run the bot

Output


Picture displays all the rows of the data table
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, March 11, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250