Hi all, I have got 2 table as below table 1 table 2 I would like to combine above 2 into 1 table by replacing the HKD & USD 3mth & 6mth with the value in 2nd table like below Currency1-month3-month6-month12-monthHKD0.10.250.30.4USD0.050.150.150.2CNY11.51.551.55 I have tried union and join tools but seems cannot make it, is there anyone could help on this? Thank you.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Combine 2 table

lity125

Hi all, I have got 2 table as below

table 1

table 2

I would like to combine above 2 into 1 table by replacing the HKD & USD 3mth & 6mth with the value in 2nd table like below

Currency	1-month	3-month	6-month	12-month
HKD	0.1	0.25	0.3	0.4
USD	0.05	0.15	0.15	0.2
CNY	1	1.5	1.55	1.55

I have tried union and join tools but seems cannot make it, is there anyone could help on this? Thank you.

Join

Accepted answers

JosephSerpis

Hi @lity125 you can use a combination of Join and Union tools to replace this data. The Join tool will replace the data you want from the second table and the union will ensure you don't lose any data that doesn't join from table 1 and table 2. I've mocked up a workflow to showcase this let me know what you think?