Force input to recognised empty first column?

[theyele]

Hi there, 

I find that when inputting from Excel, if the first field or two are empty, the Input tool sometimes automatically ignores them. But not always. 

This is causing havoc in my macros which bulk upload files, where I have to use the field location rather than name to identify it.

Does anyone know why this might happen, and how I can force it to recognise those blank fields? 

Cheers,

[gawa · Accepted solution]

hi @theyele 

If you want to forcibly read first column regardless of empty/not empty, you can utilize "Select a range" option. By doing so, it always start reading from first column even if it is empty column.

See the sample as below snapshot. Please modify the range as you wish.

[theyele]

Ah good point, thanks a lot! Didn't even occur to me :) cheers