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?

Tahreem24's avatar
Tahreem24
Super User
1 year ago

Anonymous Could you create a dummy sample data of your scenario (just 4-5 rows are enough)? So, It would be easy to  understand your data pattern and structure and accordingly I could provide some workaround. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thank you for your response!

     

    I created two sample tables, I don't know if they can help but let's see 🙂

    There can ofc be a lot of more rows and columns in the real data and tables.

     

    See the photo below (BUT there are also different Questions etc between tables(

    •