Delete multiple columns from data table

(0) Share

Report

Posted on 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:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

eetuRobo 4,522 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
CU15021716-0 20 on at

Like (0)

Report
Copy link

Link copied!

@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?)

Was this reply helpful? Yes No
Verified answer

eetuRobo 4,522 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No