topic Re: Replacing index name when loading in QlikView

Replacing index name when loading

moda1023 — Thu, 13 Sep 2018 13:25:31 GMT

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

Re: Replacing index name when loading

stigchel — Thu, 13 Sep 2018 13:40:02 GMT

Maybe but if this works it is easier

Table:

ALIAS CustomerIDs as CustomerID;

Load

....

Re: Replacing index name when loading

moda1023 — Thu, 13 Sep 2018 13:53:00 GMT

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!