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 have a dataset which looks like below. i want to create a new column that will show the type of pathway applicable for each row. For example, if Pathway_English is 1 only, then the new field (let's call it Pathway_Type) will show "English". If both Pathway_English and Pathway_Diploma have values as 1, then the Pathway_Type will be "English_Diploma". If all three are populated, then the new field will be equal to English_Diploma_Foundation. If all are 0, then the new field will be "No Pathway". Can anyone suggest a solution?
Thank you so much for your reply. It surely resolves the issue. I tried the below functions but I believe my solution is more static and yours is more dynamic. But anyways, do you think there will be any issues with this solution.
New Field (Pathway_Type)
IF [Pathway_English] > 0 THEN "English_" ELSE "" ENDIF
IF [Pathway_Diploma] > 0 THEN [Pathway_type] + "Diploma_" ELSE [Pathway_type] ENDIF
IF [Pathway_Foundation] > 0 THEN [Pathway_type]+"Foundation_" ELSE [Pathway_type] ENDIF
IF IsEmpty([Pathway_type]) THEN "No Pathway" ELSE Left([Pathway_type], Length([Pathway_type])-1) ENDIF