How to join Sales with clients from 2 databases

[#1]

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!

[martinpohl]

find an example attached

Regards

[TKendrick20]

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

[vinieme12]

<<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;

[martinpohl]

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

[vinieme12]

you are right, no need to join