Forum Discussion

DemingPDCA's avatar
DemingPDCA
Icon for Helper II rankHelper II
3 years ago

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 ...
Need Help
DemingPDCA's avatar
DemingPDCA
Icon for Helper II rankHelper II
3 years ago

if I do that - it makes a row for each course - right? I would want all of them on 1 row. 

grandtotal's avatar
grandtotal
Icon for Resolver III rankResolver III
3 years ago

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.