Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe but if this works it is easier
Table:
ALIAS CustomerIDs as CustomerID;
Load
....
Maybe but if this works it is easier
Table:
ALIAS CustomerIDs as CustomerID;
Load
....
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!