Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mhapanka
Creator
Creator
‎2018-08-30 02:58 PM

qlik sql script

Hi guys,

i want to join a table (whose data I extracted from SAP HANA) to itself . The table is named tableone

A1.left: tableone

A2.right: tableone

I would like to join it to itself, only where A2."ProductStatus" is not 'To archive'

and join on A1."Product"=A2."SystemTrigger"

Also, I want to be able to name "PRODUCTDESCRIPTION" column as "System Description"

Can someone help me code this?

530 Views
0 Likes
0 Replies