Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ecolomer
Honored Contributor II

Re: I am new in qlikview please help me

and, what is the question?

5 Replies
Not applicable

Re: I am new in qlikview 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

Not applicable

Re: I am new in qlikview 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

Not applicable

Re: I am new in qlikview 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

Not applicable

Re: I am new in qlikview please help me

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

anbu1984
Honored Contributor III

Re: I am new in qlikview please help me

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;

Community Browser