Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
gr_eldred
Creator II
Creator II

left join of two QVDS

Is there an error in this syntax? I need to make a left join between these two qvds.

Let vVtaSemanaDía = date(today(), 'YYYYMMDD');

tmp_vta_6W$(vVtaSemanaDía):

Load

%Pto_vta_ID,

Clasificación,

Cant_Estandar_Act6W

FROM

Transformación\Fact\tmp_Vta_Act_6W.qvd (qvd);

Left Join

LOAD

%Pto_vta_ID,

Clasificación,

Cant_Estandar_Ant6W

FROM

Transformación\Fact\tmp_Vta_Ant_6W.qvd (qvd);

Can you help me?

21 Replies
gr_eldred
Creator II
Creator II
Author

Thank you very much for your help, I just solved the problem.

regards

vishsaggi
Champion III
Champion III

Glad you figured it out. Could you please close the thread marking correct/helpful responses and if you post how you solved it would be helpful for other people when they search for anything similar.