Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone! I need your support. I Have the table sales which is made from two different database.
I need to link sales with clients, but I have 2 clients tables , one for each database.
How is the best way to do it ?
I attached the excel example
thank you in advance!
find an example attached
Regards
Looks like you're in need of concatenation.
Concatenation is possible in two ways accounting for whether both of your Clients tables have exactly the same fields.
Here is a resource with some examples: Concatenate Tables Qlik Sense 3.1
<<Modified Script>>
ClientS:
ClientID as CommonClientID,
Client Name
FROM TANGO;
Concatenate
ClientID &'_'&ClientOfficeID as CommonClientID,
Client Name
FROM Totvs;
Sales:
Load
ClientID &if(ClientOfficeID = 0 or isnull(ClientOfficeID ) ,'','_'&ClientOfficeID ) as CommonClientID
otherfields
FROM Sales;
LEFT JOIN(Sales)
LOAD * RESIDENT ClientS;
Drop table ClientS;
Vineeth,
this solution won't work!
while using the second join Statement there are two fields that are existing in Sales tab:
TotvsID AND Client Name (resulting from the first join).
So no dataset will be joined!
Be careful with joining, often it isn't neccessary. Think in tables and linked fields.
Regards
you are right, no need to join