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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
m4u
Partner - Creator II
Partner - Creator II

Force new Relationship without reload data

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

2 Replies
Not applicable

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

m4u
Partner - Creator II
Partner - Creator II
Author

Great idea,
thanks