Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
moda1023
Contributor III
Contributor III

Replacing index name when loading

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

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Maybe but if this works it is easier

Table:

ALIAS CustomerIDs as CustomerID;

Load

....

View solution in original post

2 Replies
stigchel
Partner - Master
Partner - Master

Maybe but if this works it is easier

Table:

ALIAS CustomerIDs as CustomerID;

Load

....

moda1023
Contributor III
Contributor III
Author

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!