Free Trial

Alteryx Designer Desktop Discussions

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

Un-summarising Data

DHB
8 - Asteroid

Hi all,

 

I have some summarised data that I need to take back to a more granular level in order to visualise it.

 

What I have looks like this...

 Group

Campaign

Outcome

Count

A

First

Good

1

A

First

Bad

2

A

First

Other

3

A

Second

Good

2

A

Second

Other

1

B

First

Bad

4

B

Second

Good

2

B

Second

Other

3

 

What I’d like to get to is this...

 Group

Campaign

Outcome

A

First

Good

A

First

Bad

A

First

Bad

A

First

Other

A

First

Other

A

First

Other

A

Second

Good

A

Second

Good

A

Second

Other

B

First

Bad

B

First

Bad

B

First

Bad

B

First

Bad

B

Second

Good

B

Second

Good

B

Second

Other

B

Second

Other

B

Second

Other

 

Any advice would be greatly appreciated.

 

Best,

 

DHB



2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

Hey @DHB 

 

You can use the generate rows tool. See attached.

DHB
8 - Asteroid

That's perfect, thanks Philip.  I'd been playing around with that tool but hadn't been able to configure it correctly.

Labels
Top Solution Authors