Create a new table from columns from existing tables

[HEW]

Hi.

I would like to create a new table based on 2 existing tables.

Table "Currencies" consists of one column "Fra" with the values: 

DKK

CAD

GBP

SEK

Table "Dates" consists of one column "Fulldate" with dates as follows (example):

01-01-2018

02-01-2018

03-01-2018

04-01-2018

05-01-2018

The new table should consist of both tables, so the data should be (in one column:

01-01-2018-DKK

01-01-2018-CAD

01-01-2018-GBP

01-01-2018-SEK

02-01-2018-DKK

02-01-2018-CAD

02-01-2018-GBP

02-01-2018-SEK

And so on....

How can I create such a table?

Thanks a lot in advance.

[rohit01 · Accepted solution]

Hi Hew, 

you can acheive this by using following steps:

Create New table using CrossJoin  & then calculated column : use concatenate to acheive desired result, please refer to snapshot below:

Create Newtable using CrossJoinCreate Calculated column shown as "Result" above and use concatenate ()

I hope that helps 🙂

Please dont forget to accept it as solution if it works 🙂 

[HEW]

It worked perfectly - thanks a lot.

Br. Helen

[rohit01]

Hi Hew,
Could you please confirm if table "Currencies" and "Dates" are related , if yes, on what condition you want to concatenate two columns?

Thanks
Rohit

[HEW]

Hi Rohit.

The existing tables are not related.

Br.

Helen