Delete multiple columns from data table

Like (0) Share

Report

Posted on 15 Feb 2025 17:18:23 by CU15021716-0

I have data table as a variable scraped from an html table

How do I delete the first 3 columns using Index?

Do I have to add an action for each column? If so is the index o each time, or is it 0 in action 1, 1 in action 2, etc.?

Categories:

Business Process Flows

All responses (3)

Answers (1)

Verified answer

eetuRobo 3,387 Super User 2025 Season 1 on 19 Feb 2025 at 17:08:39

Like (1)

Report

Delete multiple columns from data table

@CU15021716-0 Good to hear that you figured it out

(maybe because I ticked the box to 'Enable Power FX' when I created the flow?)

Yes that exactly right. With Power Fx the indexing starts from 1 rather than in the regular flow where it starts from 0.
CU15021716-0 20 on 19 Feb 2025 at 14:32:03

Like (0)

Report

Delete multiple columns from data table

@eetuRobo Thanks for your reply,

I found it didn't work like that for me (PAD v2.52) -

It wouldn't accept 0 as the first column. I had to create 3 'Delete column' actions, each specifying column 1.

(maybe because I ticked the box to 'Enable Power FX' when I created the flow?)
Suggested answer

eetuRobo 3,387 Super User 2025 Season 1 on 19 Feb 2025 at 14:15:00

Like (0)

Report

Delete multiple columns from data table

Yes datatable indexing starts from 0 so first column would be 0, second 1 and third 2. To delete a column you can use "Delete column from data table" -action.

So if you want to delete multiple columns you should either delete the index 0 three times in a row or delete first the highest column index and go from the top down. Because if you delete the first column then the second column will become index 0 and third column will be index 2.

For example I extract html table and want to delete first three columns:

I can do it like this:

Or loop the deletion of index 0 for three times:

Then I will have removed the first three columns: