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 ...
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.