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

Formula Help

Raj_2
8 - Asteroid

Hi there, I am creating a work flow where I need a help on this piece.

 

There are 3 emp ids where based on one code BA & HP the coding will be decided, if it BA and HP then coding will be 22 . if it is only BA then it is 11.

 

Can you help me as per the attached pic. I am stuck here and my other work flows are ready which is linked to this.

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Raj_2 

 

Here's a way of solving this problem:

 

BASolution.PNG

- Group by ID and concatenate all of your codes

- Use formula to Flag ID's with BA and HP

- Join the flag (22 or 11) to your dataset

- To leave the coding to the BA cell, you can apply another formula and just give null values to records that are not equal BA.

 

WF attached.

 

Cheers,

DataKyle
8 - Asteroid

Does this work for you?

 

I summarized the codes into 1 field and used a formula tool to provide the Coding values. 

Labels