Connections between tables

[da_pagnott]

Hello guys,

I have a questions about connections, and maybe someone can helpo me please..!

Do I have any way to connect two tables with two common fields?

I have two data sources, with different format, but with customer name and data value in commod.

I'd like to merge values in my dashboard in one single table because I have some customer in one table and some in the other one. I need then to split values per month, so maybe I have to set a connection also between data fileds?

Please find attached an example of my actual association.

Thank you very much!!

[Ivan_Bozov]

Hi, you can create a key field like this:

Table1:
FieldA & '-' & FieldB AS Key

Table2:
FieldC & '-' & FieldD AS Key

[Channa]

u can do concatenate between two tables to make union

try to have same number of columns and data formats