Create Key of 2 Columns from Different Table or Concat of 2 Fields

[harry_16]

Hello Everyone,

I am trying to add or create new table which will include the concat of 2 existing columns from different tables. Below is the sceanrio

LIB CONNECT TO "Final_DB"

[Outbound]:

Load "address" as [Origin address]

From DB (query to call data)

[Inbound]
Load "address" as [Destination address]

From DB (query to call data)

How can I add or do Concat of both "Origin address - Destination Address"? 

I want to create the key to map this with manual excel master data sheet. 

Looking forward for your support !!

[Clement15]

Hello, do you want all the possibilities of Outbound and Inbound? If yes you can do this.

[Outbound]:
Load "address" as [Origin address]
From DB (query to call data)

Join

[Inbound]
Load "address" as [Destination address]
From DB (query to call data)

Final:

Load
[Origin address] & '-' & [Destination address] as Concat
Resident [Outbound] ;

[harry_16]

Hello 

Thanks for the reply

I have tried using above suggestion and I got error when I load the data. Showing Error Origin adress not found.

[Clement15]

With my test code it works, can you take inspiration from it for your own code ?

TEST:
Load * Inline [
TEST1
OUI
NON

];

join

TEST2:
Load * Inline [
TEST2
OUI2
NON2

];

TEST3:
load
TEST1 & '-' & TEST2 as TEST3
resident TEST;