Modern Extract Table Data Wizard removes only header, not column

Help Studio
1

Hello,

I’m scraping the Acme system 1 work items page using the modern Extract Table Data activity. In the wizard it shows the option to delete a column/header from the scraped data. However, instead of deleting the entire column, it only deletes the header and the other headers shift, so the data is no longer aligned after that.

Is this a bug?

Documentation says this: “Each column can be individually edited or deleted, enabling you to customize your final table however you see fit.”

Based on this I assumed it would delete the entire column when clicking the bin icon.

Data before deleting “Actions” column:

image
image717×160 29.1 KB

Data after deleting “Actions” column:

image
image735×141 24.7 KB

Now the WIID’s are listed under the description column, and description under type etc.

Thanks!

2

Hi @EvelineL
instead of extracting it as whole table itslef, Can u try to extract column by column

That would be good approach i thonk

Regards,
Nived N

3

Hi

Please upgrade the packages in Design tab-> Manage Pacakges → Project Dependencies

UiPath.System.Activity
UiPath.UIAutomation.Activity

And give a try

Or

First get all the columns with data scrapping
And get the output with a variable of type dt

Then use a assign activity like this to get the required columns you want

dt = dt.DefaultView.ToTable(False,”columnname1”,”columnname2”,…,”columnname an”)

This will give Only the mentioned column in the datatable dt

Cheers @EvelineL

4

Hi Palaniyappan,

Thank you, updating the packages resolved the issue! I now also see the “Edit extract Data” button which I was missing before, so that’s great!

Thanks!

1 Like
5

Glad @EvelineL

6

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