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.

[Emil_Kos]

Hi @lity125,

Find and replace with this configuration should work for you:

You would need to use it twice as there are 2 columns that you want to replace. 

[JosephSerpis · Accepted solution]

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?

[afv2688]

Hello @Emil_Kos,

This is how I would do it using the join tools:

Regards

[smoskowitz]

Hi @lity125 --

Take a look at my solution. I tried to create it to be Dynamic for you. You can of course alter it to be more dynamic, but it appears to work.

I hope this helps!

Thanks,

Seth

[lity125]

I used the method of join and union and it works! Thanks all for your help.