Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Combining tables based on two columns, text and date

Hi

I want to do a lookup across two tables matching two fields.

Table 1 and 2 has name and date as does table 2.

I want to combine these tables into a new table "Calculation Table" and then do calculations on the values.

I have tried to concatonate the Name and Date and link the concatonated colums but its not working.

Just wondering if anyone can help me.

Thanks

MFelix
8 years ago
Hi Anonymous,

You can do one of two things:

Merge table

In query editor use the Merge query (can be done by more than a column

Create two dimension table and make relationships between these two table and the other two:

Dates table

Name table (Distinct name in both tables)

Then add a measure with the difference between column A e column B.

Regards,

MFelix

3 Replies

MFelix
Super User
8 years ago
Hi Anonymous,

You can do one of two things:

Merge table

In query editor use the Merge query (can be done by more than a column

Create two dimension table and make relationships between these two table and the other two:

Dates table

Name table (Distinct name in both tables)

Then add a measure with the difference between column A e column B.

Regards,

MFelix
- Anonymous
  Not applicable
  8 years ago
  Thanks for this.
  
  I also solved this by using concatination.
  
  In both tables i combined the name and date using the concatination command.
  
  So then i had a column in each table that i could link.
  
  This allowed me to build the relationship i needed.
  
  thanks for your help
  
  James
- Anonymous
  Not applicable
  8 years ago
  Thanks Felix