Hi,
I have an input table like this-
And I want table like this from the above table-
How I can do this by using Alteryx? I tried using Cross Tab but it didn't work.
Thanks
tile tool - unique value - name
cross tab - tile seq as key column
name as columns
value as value.
Hi @amitsingh88 ,
to achieve the result using the Cross Tab tool, you need a specific row id. You can easily create an id using the Multi-Row formula tool thereby adding a "row counter" for each [Name].
Create a new filed [RowId] and create a counter for the group (= [Name]).
This can be used in the Cross Tab tool as a "group by" field and identifies the rows; even though you use Concatenate as an aggregation method, the group by field leads to one entry per row.
It should produce exactly the result you need.
I've attached a sample workflow. Let me know if it works for you.
Best,
Roland