SOLVED
Delete columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bmeena
5 - Atom
‎01-27-2023
11:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Dynamic Processing
4 REPLIES 4
21 - Polaris
‎01-27-2023
11:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bmeena
Maybe we can sequence the columns with Tile tool then filter out SN>4
17 - Castor
‎01-28-2023
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bmeena if I'm understanding the question right, you should just be able to use a Dynamic Select, leveraging the FieldNumber variable:
binuacs
21 - Polaris
‎01-28-2023
05:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎01-28-2023
05:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
'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.
