Hello,
I'm kind of new to Alteryx and haven't yet gotten the hang of manipulated tables in the program
I was wondering if anyone knows of an efficient way to convert a variable that is a concatenation of non-exclusive attributes (such as a variable named keywords that looks like this: "1920's|antique|american") into columns with a binary variable (variables named keyword_1920's , keyword_antique and keyword_american that are either TRUE or FALSE.
First, I would need to find all the unique keywords currently concatenated in the various keywords strings
Second, I would need to turn them into columns and append them somehow to the table.
Third I would need to populate the fields of the newly created columns with TRUE or FALSE based on the keyword appearing in the concatenated string of that row.
Any Ideas?
Thank you,
Talks2Rocks
Solved! Go to Solution.
This was very clever. I'm looking forward to inspire all the more.
Cheers,
Mark
Better?
Though I think @NicoleJohnson has beat me to it :)
Thank you Nicole! This is just what I was looking for.
Cheers,
Talks2Rocks
Thank you for all the help!
Cheers,
Talks2Rocks