Replacing index name when loading

[moda1023]

Hello ,

so right now i'm trying to import data from a couple of excel sheets. This actually is working, but i noticed a spelling error in one column. So instead of CustomerID sometimes you have CustomerIDs. My code right now looks like this:

Is there any way to check if in the current file in the loop the index CustomerIDs is available. And then rename it to CustomerID?

Kind regards,

Daniel

[stigchel · Accepted solution]

Maybe but if this works it is easier

Table:

ALIAS CustomerIDs as CustomerID;

Load

....

[moda1023]

Thank you very much!

I was having problems because of the loop. When it wasn't finding CustomerIDs in a sheet it would show me a error message.

But after placing ALIAS CustomerIDs as CustomerID; before the next it worked!