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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
triciagdaly
Contributor III
Contributor III

How to join a column in one table to another

In the attached example, I'm trying to add (join ) the column 'CP_AMOUNT'  in StdCostDateRange table to the Receipts table.  The common field is ITEM_NUMBER.

I tried  LEFT JOIN (Receipts) after the 'NoConcatenate' on the StdCostDateRange table, but it doesn't accept it.

1 Reply
whiteline
Master II
Master II

Hi.

I guess there is no RECEIPT_DATE field in your data model. So there is nothing to interval match an therefore nothing to join.