Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Douwe_KB
Contributor II
Contributor II

Translating SQL statement to Qlik

SELECT ABAN8, ABALPH, DRKY, DRDL01 FROM PDTSDTA.F0101, PDTSCTL.F0005

 

WHERE DRSY='41' AND DRRT='S2' AND ABAN8 = 100

 

I have this SQL statement which does exactly what I want: for each customer number (ABAN8) give all possible productgroups as follows: 

 

Screenshot_20230411-163607.jpg

 however, I can't figure out how to do this in Qlik. I have access to all these JDE tables. Any help is appreciated

Labels (3)
2 Replies
sandeep-singh
Creator II
Creator II

Try this, If the code didn't work, then I request you to share a dummy sample of data for further analysis

PDTSDTA_F0101:
LOAD ABAN8, ABALPH, DRKY, DRDL01
FROM PDTSDTA.F0101;

PDTSCTL_F0005:
LOAD ABAN8, DRSY, DRRT
FROM PDTSCTL.F0005
WHERE DRSY = '41' AND DRRT = 'S2' AND ABAN8 = 100;

Join (PDTSDTA_F0101)
Load ABAN8, DRSY, DRRT
Resident PDTSCTL_F0005;

Drop Table PDTSCTL_F0005;

MayilVahanan

Hi

You can directly use this sql statement in Qlik.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.