Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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