Forum Discussion
Create a string that "compounds" based on conditional statements
I need to create a string that compounds based on if there is a value in the column. I have a table that has a different column for each course (if they have completed the course there is a ...
DemingPDCA , you need to unpivot the course columns.
Check out this:
The best way may be the 'unpivot other columns' option: select the non course columns and unpivot other.
if I do that - it makes a row for each course - right? I would want all of them on 1 row.
you can do it on visualization but you have to unpivot the data table.
if you post a sample dataset (PFP Check table) we can help you to better understand.
You are both correct. It will make a row for each course in the table in your model. However, you can still put them all on a row in a matrix visual as a single field.
