Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Table connection

Hello, what are the solutions to connect 2 tables, when there aren't any unique similar columns. If you have e.g. two survey data from different years (2022 and 2023). If there are some same question...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    It seems I solved the problem, there is a solution which seems like to work (this is anonymised and sample):
    Combined_Data = UNION( SELECTCOLUMNS('Table1', "Year", 'Table1'[Year], "Question1", 'Table1'[Question1], "Question3", 'Table1'[Question3], "Customer Loyalty", 'Table1'[Readiness to recommend]), SELECTCOLUMNS('Table2', "Year", 'Table2'[Year], "Question1", 'Table2'[Question1], "Question3", 'Table2'[Question3], "Customer Loyalty", 'Table2'[Readiness to recommend]) )


    So I made a new table that includes the column I need from both tables. Do you think there can be some problems or limitations with this solution / way? Or does it looks like a decent or good workaround?

divyed's avatar
divyed
Super User
1 year ago

Hello Anonymous ,

 

Create a row_number column in both the tables based on "Questions" and use this row_number column to join tables.

1. It will connect both the tables based on questions

2. You can apply different type of joins (while merging) to cover all data.

 

I hope this helps.

 

Please mark this as solution if this has solved your query. Appreciate Kudos always :).

 

Cheers