Forum Discussion

krdavies's avatar
krdavies
Icon for Helper I rankHelper I
6 months ago
Solved

Concat two values from dimension table into fact table

Hello everyone, 

 

I am working with a database tracking workshop registration. I have registrations and workshops as fact tables and a number of dimension tables handling participant, instructor and series data. A workshop can have multiple instructors and I would like to be able to show in a table the details of a given workshop with both instructors on the same line but I'm not sure where to start. I am attaching a sample version of the dashboard. You will be able to see that 5 workshops in my dataset have 2 instructors each. My goal is for the workshops to appear once in the table with data in the instructor column showing Name1, Name2. 

 

Sample dashboard: https://drive.google.com/file/d/1wNJIFuhfSeWsuIQMbme6fyN9oIZVLZSq/view?usp=sharing

Sample data: https://docs.google.com/spreadsheets/d/1XWVeEnh5jASMZNOwSwc2H1rwvDBiDj6z/edit?usp=sharing&ouid=114983625976234197400&rtpof=true&sd=true 

3 Replies

    • krdavies's avatar
      krdavies
      Icon for Helper I rankHelper I

      Thank you! This worked perfectly and I've learned something new that I can see will be very useful in other areas. 

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User

        Hi krdavies ,

         

        Don't forget to accept the correct answer so it can help others.