how do I uncheck all columns while opening a file

[Sundaram Sridharan]

I have a file with several hundred columns and I only need a handful. in File open dialog box, I see all columns selected by default. I then have to uncheck those I don't need. Is there a way to uncheck all of them in one shot and only select those few I need. There muse be a way to do this.

[Kirsten Smith (she/her)]

After selecting your file you should see an option to Transform Data. Add the 'Exclude Columns' transformation, then you can Remove All and add back in just the columns you need.

[Sundaram Sridharan]

Thanks. This works after reading in the file and selecting transform under "insert"