Hi,
New to Alteryx, but wanting to add unique variables in a column (Brand) to the end of a dataset to form column headings. Currently I have 'duplicate' rows (aka 2 or more of the same 'Name').
Atm, my data looks like the below:
Want it to look like this:
Thanks!
Solved! Go to Solution.
Hi @EmAnna
Something like this should do the job. I've just found the counts in a summarize based on name and brand (essentially just giving us a field to populate cells in the next step), then cross-tabbed so the headers are the brands, and the count is the values, then turned the nulls into 0.
@EmAnna - Try out the Cross Tab Tool. First use a Formula tool to hardcode a 1 on each row of data and call it count. Then use a Cross Tab Tool and group by Name and Brand, use Location for the Column Headers and Count as the value under the new Columns. For your aggregation method use Sum.
Good luck!
Thanks all for the above - solved!