Keep the left most null columns when importing

[Sumaya52]

Hi all,

I've an excel file where the first column is null. Upon importing the file on alteryx, this column is dropped but I want to keep it. Any idea how to configure alteryx to do that?

Thank you!

[binuacs]

@Sumaya52 try the below option checked in the input tool and run

[gautiergodard]

Hey @Sumaya52 

You would be able to do this by specifying the cell range which you'd like to import.

First click the 3 dots next to table or query: 

Then enter the cell range:

If you do not check this option, the input will automatically remove the first null column you are referring.

Hope this helps!

[Sumaya52]

Good idea! However, I'm working with multiple dynamic files and the range end for each file is different. I wonder if there is a keyword for Alteryx to implicitly specify the range end for each file accordingly?

[Sumaya52]

Thank you for replying. Unfortunately I've tried that but the first column is still dropped.

[binuacs]

@Sumaya52 Would you be able to provide some sample files also would you be able to check any warnings or errors in the result window when you run the workflow?