Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Delete columns

bmeena
5 - Atom

I have an excel file with 2000 rows and 30 columns . I would like to delete all the fields from 4th columns . Is there any tool available to dynamically delete columns in Alteryx. Please suggest 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@bmeena 
Maybe we can sequence the columns with Tile tool then filter out SN>4

0128-bmeena.PNG

DataNath
17 - Castor
17 - Castor

@bmeena if I'm understanding the question right, you should just be able to use a Dynamic Select, leveraging the FieldNumber variable:

 

DataNath_0-1674912804168.png

DataNath_1-1674912819676.png

binuacs
21 - Polaris

@bmeena slight update to @DataNath solution, since you want to remove column 4 you can use the below formula in the dynamic select tool

 

binuacs_0-1674913040957.png

 

DataNath
17 - Castor
17 - Castor

'I would like to delete all the fields from 4th columns' suggest that they want to delete all fields after the 4th but I guess @bmeena can confirm. Either way, Dynamic Select should be able to get the job done.

Labels
Top Solution Authors