This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to be able to generate 3 rows one below the other for the above person, as he has values more than 0 in 3
different columns, and while generating 3 rows, we need to map them to LEARNER_PHYSICALCLASSROOM, INSTRUCTORAP_PHYSICALCLASSROOM and AUTHOR_PHYSICALCLASSROOM in a column called status, with all the other values being the same in the row., we would not need the last 4 columns once we do this.
Like wise, we need to have as many new rows added for the same user as and when he has values more than 0 in the last 4 columns,
Web-Based Learning (Self-study)
Distance Learning (Instructor-led)
Classroom Learning (Instructor-led)
Virtual Learning (Instructor-led)
1) If he has one value of more than 0 across 4 columns, no need to add a row, it would be just to add a new column and map it to any one of the above said status
2) if he has 2 values of more than one, add one row, with the first row to be mapped to the status name and second row as well to another.
3) and so on.
attaching the mapping and a sample data set. Please help.
One way to do this is by using the transpose tool to map the last 4 columns to their corresponding status using course method and the column names. The final step filters out any rows with values = 0. Hope this helps!