Alteryx Designer Discussions

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

Combine two lines based on condition

rafatomillero
7 - Meteor

I want to combine the lines where there is a 5 and below a 0.242 to show 5.242. Likewise, I want to combine the ones that are a 9 and below 0.242 to show 9.242. How do I achieve this?

 

rafatomillero_0-1659351403192.png

9 REPLIES 9
grazitti_sapna
16 - Nebula

Hi @rafatomillero, is this 0.24 a constant or it could be any decimal number?

Sapna Gupta
rafatomillero
7 - Meteor

Hi @grazitti_sapna, it would be a constant. The picture I attached is all the data I have.

Emmanuel_G
13 - Pulsar

Hi @rafatomillero ,

 

Find solution attached

Emmanuel_G_0-1659352818274.png

 

binuacs
17 - Castor

@rafatomillero one way of dong this

 

binuacs_0-1659352981231.png

 

grazitti_sapna
16 - Nebula

@rafatomillero, my workflow contains two methods one is dynamic and one is based on constant.

grazitti_sapna_0-1659353175467.png

 

 

Feel free to use any of them as per requirement.

 

Thanks!

Sapna Gupta
rafatomillero
7 - Meteor

Hi @Emmanuel_G , that's great! but in the New Field how do you delete 5 and 9 where below [Premium Tax Rate Applied] = 0.0242? I don't need them to show in the data. The last two 9 are fine to show because they do not have 0.0242 below.

Emmanuel_G
13 - Pulsar

@rafatomillero 

 

Attached solution desired

Emmanuel_G_0-1659354274340.png    

Emmanuel_G_0-1659354338056.png

 

 

grazitti_sapna
16 - Nebula

@rafatomillero, updated workflow if it helps.

grazitti_sapna_0-1659356047899.png

 

Thanks!

Sapna Gupta
binuacs
17 - Castor

@rafatomillero updated the workflow 

 

binuacs_0-1659357337539.png

 

Labels