If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I’m looking to combine 2 tables together Consumption and Site.The id that I want to combine them with is MPRN however Site will only contain one instance of each MPRN value whereas Consumption will have many.Example:Consumption:
To be merged into:
Does anyone know how to achieve this?Any help is much appreciated.
Consumption:LoadMPRN,Consumption,Date,RecNo() as RecordNoInline [MPRN,Consumption,Date123,80,01/01/2015123,90,01/12/2014125,110,21/07/2012125,120,08/12/2014125,115,01/10/2014];
FinalTable:Load * where not Exists(MPRN_Check);LoadMPRN,MPRN as MPRN_Check,Consumption,Date,RecordNo as RecordNoCheckResident Consumption;Drop Field MPRN_Check;
Left join(FinalTable)Load * Inline [MPRN,Name,Active123,ABC,Y125,DEF,Y];
Concatenate(FinalTable)Load*Resident ConsumptionWhere not Exists(RecordNoCheck,RecordNo);Drop Table Consumption;
Drop fields RecordNoCheck,RecordNo;
And the result is: