Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Some times after loading large data to my qlikview file, i understand that the relations between objects are not correct (because of identical field names).
in this case i have to change some field names using an alias (EntryID AS InvoiceNumber), and reload the script.
there is an option to do that without reload the data (for example: changing the field name with any macro, and forcing qlikview to Reorganize the relations)?
thanks,
shlomo
You can use a self binary load statement, meaning load the data model from the same file and do the appropiate renaming thorugh the rename statement,although this could be a quick fix, the actual fix has to be done during a load statement.
Write a code similar to these:
binary "file.qvw"
//Main tab
set....
set...;;
rename field EntryID as InvoiceNumber;
exit script;
//the rest of your actual load script goes after the exit script statement.
Regards