Remove Data Column by index

Help Studio
1

Hi Guys,

Trying to remove column 6 + 7.
Do I have to use 2 seperate actions or all on one line.
Ive tried in expression 6&7 6,7 (6&7) , no luck. :roll_eyes:

Thanks guys

2

Hi @MikeC ,

Have you used Filter datatable Activity and mentioned the indices you want to remove?

image

2 Likes
3

No buddy, using the remove column activity rather than the filter.
Just wondering if it accepts 6+7 ?

Thanks

4

when doing it with remove data column:
2 sperate activities
Start always with the highest index
and delete then descending

otherwise it will get confused as after the first deletion for sure the index are also changed

1 Like
5

Hi Peter, that is quite clunky isnt it, thanks for explaining.
Think il stick with the filter, thanks to all :grinning:

6

If they are adjacent columns you can start with the lowest and just use the same index number in each activity.

1 Like
7

Ahh interesting :ok_hand:

8

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