Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ecolomer
Master II
Master II

Re: I am new in qlikview please help me

and, what is the question?

5 Replies
Not applicable

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

Not applicable

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

Not applicable

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

Not applicable

but i am doing the same synthetic key is coming how to remove that

anbu1984
Master III
Master III

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;