Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is Qualifier ? i am new to qlikview,can any one tell me with the help of example ?
Qualify does not work that way when you concatenate files. Although you are not using the CONCATENATE keyword, it is happening because you are loading multiple files (DSI*.csv). QUALIFY, as you already know, prefixes each field with the name of the table, and each iteration of a concatenation with QUALIFY will end the table label with "-1", "-2" and so on.
So you will have to do two steps. First a noncatenated load of all fields from the DSI*.csv files, store them into QVD files, then using QUALIFY load all fields from this other load. However, in your case, I'd concatenate the Invoices and Credits table as I suggested in a previous post.