Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Join table, resident table

Hi, I'm quite new to QlikView and am having some problems with a particular join statement.

Will the following cause problems for QlikView?

JOIN(Claim)
LOAD claimNumber,
authNumber&EpisodeNumber as comorbid_claim_link
Resident Claim;


Should I rather do something like:


Temp:

LOAD claimNumber,
authNumber&EpisodeNumber as comorbid_claim_link
Resident Claim;


Join(Claim)

LOAD claimNumber,
authNumber&EpisodeNumber as comorbid_claim_link
Resident Temp;


Drop table Temp;


Tags (2)
1 Reply
edddddy24
New Contributor

Re: Join table, resident table

hello.

do you already found the answer? if not, what about this:

maintable:

load

field1,

field2

from x.qvd(qvd);

left join(maintable)

load

field1,

field3

resident restable;

i hope it works for you.

Community Browser