This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I'm trying to join multiple tables in order to make links between my tables and I'm facing an issue when "creating" a new field.
Table 1 - Invoice
Table 2 - Order
Table 3 - Client
Table 4 - ClientMovement
So, I made this but I'm stuck for 2 reasons.
[Invoice]LOAD FactId, FactDate, FactJournal, FactNo, FactSite, Year(FactDate) &'|'& FactJournal &'|'& FactNo &'|'& FactSite AS ClientDocNoFROM [lib://.../invoice.qvd] (qvd);
LEFT JOIN([Invoice])LOAD InvoiceId, TEXT(RTRIM(DeliveryClientNo)) FROM [lib://...Order.qvd] (qvd);
LEFT JOIN[Invoice])LOAD TEXT(RTRIM(DeliveryClientNo))FROM [lib://.../Client.qvd] (qvd);
After that, i do not know how to make my link between my CLIENT and INVOICE table and to create the field I need for having the ID of table 4.
Can someone please help me?
Have a nice day
Since you've used LEFT JOIN, there is no longer a Client table - its fields would be contained within the Invoice table. Note that the additional fields you need for your key don't appear to be in the load script, so you'll want to add them.
You can e.g.
Load *, Field1 & Field2 as NewKey
Drop Table Invoices;
Or you could:
Load SomeUniqueID, Field1 & Field2 as NewKey