Force input to recognised empty first column?

Question

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 Answer

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.