topic Force new Relationship without reload data in QlikView

Force new Relationship without reload data

m4u — Thu, 14 Oct 2010 20:16:17 GMT

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

Force new Relationship without reload data

Thu, 14 Oct 2010 20:31:05 GMT

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

Force new Relationship without reload data

m4u — Thu, 14 Oct 2010 20:39:41 GMT

Great idea,

thanks