Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Double some rows in a column and change text, while rest of data are also doubled

arieta
8 - Asteroid

Hello, I have some trouble on presenting my data like the table below:

Data as is now:

Type

Stage

Data1

Data2

Apple

NON-METASTASIS ORANGE

0.01

0.2

Apple

METASTASIS ORANGE

0.3

0.5

Apple

LOCAL ADVANCE

0.4

0.3

Apple

ALL CATEGORIES

2

4

 

My goal is to double some rows and change some of the text in the ‘stage’ column in the ‘new stage column’, while the ‘Data1’ and ‘Data2’ rows are also doubled. Please see an example below:

Type

Stage

New stage column

Data1

Data2

Apple

NON-METASTASIS ORANGE

STAGE I ORANGE

0.01

0.2

Apple

NON-METASTASIS ORANGE

STAGE II ORANGE

0.01

0.2

Apple

METASTASIS ORANGE

STAGE III ORANGE

0.3

0.5

Apple

METASTASIS ORANGE

STAGE IV ORANGE

0.3

0.5

Apple

LOCAL ADVANCE

STAGE III

0.4

0.3

Apple

ALL CATEGORIES

ALL STAGES

2

4

 

Thank you in advance!

2 REPLIES 2
RobertOdera
13 - Pulsar

Hi, @arieta 

 

Please try the below.

Please mark as an acceptable solution and like, if this works for you.

 

Solution

RNO2_2-1590682195738.png

 

Workflow

RNO2_3-1590682213692.png

 

The workflow is attached.

Cheers!

BrandonB
Alteryx
Alteryx

stages example.png

I think that this should get you close. I set it up to leverage a lookup table that specifies how many rows will be generated based on the stage. You can tweak this to your liking. Workflow is attached. 

Labels