Remove rows in generate data table

Good day!

Need help. I generated a data table from a text file and i want to remove rows (encircled in red) that I dont want to use.

Hi,

Can you try Filter DataTable activity as the following?

Regards,

how can I also use the first row as column headers? if I select the box and it will output like in the screenshot. the data in the first 4 columns were deleted.

Hi,

Can you share your text, if possible?
Basically we can set first row as header. However, in some cases, we might need string manipulation before then.

Regards,

please see attached text file

veip_data.txt (614 Bytes)

Hi,

it seems wizard issue. The actual activity seems to work correctly.
Can you check the following sample?

Sample20210514-1.zip (2.7 KB)

Regards,

thank you on the solution. 1 thing how can i write the output from the filter data table to the google sheet?

here is the screenshot of the google sheet

Hi,

Can you try Write Range in UiPath.GSuite.Activities package.

https://docs.uipath.com/activities/docs/gsuite-write-range

It’s required some settings in advance. The following helps you.

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.