Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

condensing rows

onsga006
5 - Atom

Screen Shot 2021-11-10 at 12.52.45 AM.png

 

How would I condense the rows so that the sum expense for each country is in the same row as the manager and team size for each country?

1 REPLY 1
AngelosPachis
16 - Nebula

Hi @onsga006,

 

You can try using a transpose tool and select the Country field as a Key column.

 

Then with a filter tool, you can select to exclude the null values under the [Value] field (Value is not empty would work as well).

 

Finally with a crosstab tool, select to group by country, column headers to be under the [Name] field and the values for the new columns to originate from the [Value] column. Method of aggregation can be "Concatenate".

 

I believe this will do what you are looking for.

 

Best,

Angelos

Labels