Discussion board where members can learn more about Qlik Sense App Development and Usage.
I would like to replicate the following join using Qlik syntax because one of my tables is SQL and the other is in Excel. How can I do this?
FROM [Investment] AS inv
INNER JOIN [Relationship] AS rel ON inv.InvestmentCode = rel.InvestmentCode
LEFT JOIN [Investment] AS tFloatLeg ON rel.FloatingLegCode = tFloatLeg.InvestmentCode
LEFT JOIN [Investment] AS tFixedLeg ON rel.FixedLegCode = tFixedLeg.InvestmentCode
Go to Solution.
Hi. I solved my own problem:
(ooxml, embedded labels, table is Sheet1);
//map the relationship to itself
InvestmentCode AS FloatingLegCode
,MetaData1 AS SomeOtherMetaData