Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.