Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
and, what is the question?
my question is how can i implement this in qlikview script
say for person table i am written one script and saved in person qvd
anather i saved in sales qvd
now i want to get both qvd with these join condition,How can i get this
please help me
my question is how can i implement this in qlikview script
say for person table i am written one script and saved in person qvd
anather i saved in sales qvd
now i want to get both qvd with these join condition,How can i get this
please help me
Qlikview automatically joins tables based on field names. So all you have to do is LOAD the qvd files and make sure the fields are named equally: PersonId, positionid
but i am doing the same synthetic key is coming how to remove that
Use Autonumber() and rename field names as below
Load A,B,CAutonumber(A&'_'&B) As Key From First.qvd;
Load A as A1,B as B1,D,Autonumber(A&'_'&B) As Key From Second.qvd;