Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I’m puzzling on a problem for which you might have a simple solution.
I have 2 tables which I'd like to join. In the 1st table I have the production order with different operations. The combination of the order number and an operation is the object No. and on each single combination I’d like to do a comparision of planned versus actual hours.
In the 2nd table I have different status to this object No (in 1 column) and if I combine these 2 tables I have multiple entries, which I want to prevent.
So, I thought I’d like to join the serveral status (which are saved in several data cells) into 1 field and combine this new field via the object No with table 1. With the filter function I can filter the requested status and do the planned / actual comparison.
Is that possible? Is there maybe a script function like crosstable for such a task? Please check the attached excel, it's difficult to explain.
Thank you very much in advance.
Best regards
Christine
TRy something like this.
LOAD
Auftragsnummer,
Vorgang,
[Objekt-Nummer],
[Plan Stunden],
IstStunden
FROM Tabelle1;
LEFT JOIN LOAD
[Objekt-Nummer],
Concat(Status, ' ' ) as Status
FROM
Tabelle2;
The key here is the Concat-function: https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/StringAggr...
YES! It's working 🙂
Thanks a lot and greetings from snowy Switzerland
Christine