We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to compare data e correct sufix based on some conditions

wcamarg3
8 - Asteroid

Hi all,

 

I hope anyone can help me.

 

I have a table with serial numbers, date, status and OP.

When there is a "NOK" status it places a suffix "1" on the OP, and I would like to correct it.

 

So, every time there is a "NOK" it should compare it with the "Checkpoint" Status, find the same Operation "prefix", "middle" and correct the "sufix". 

 

Below an example of what I want:

 

SNDate & TimeStatusOP
X129/29/2021 21:47CompleteA_110_4
X239/29/2021 21:03CompleteA_110_4
X239/29/2021 21:02CompleteA_110_4
X239/29/2021 21:00CompleteA_110_4
X339/29/2021 10:50CheckpointA_120_3
X339/29/2021 11:48NOKA_120_1
X339/29/2021 11:53OKA_120_3
X459/29/2021 11:53CompleteB_10_4
X459/29/2021 11:48CompleteB_10_4
X459/29/2021 10:00CompleteB_10_4

 

According to "Checkpoint" the "NOK" Status should be "A_120_1".

 

Below the desired table:

 

SNDate & TimeStatusOP
X129/29/2021 21:47CompleteA_110_4
X239/29/2021 21:03CompleteA_110_4
X239/29/2021 21:02CompleteA_110_4
X239/29/2021 21:00CompleteA_110_4
X339/29/2021 10:50CheckpointA_120_3
X339/29/2021 11:48NOKA_120_3
X339/29/2021 11:53OKA_120_3
X459/29/2021 11:53CompleteB_10_4
X459/29/2021 11:48CompleteB_10_4
X459/29/2021 10:00CompleteB_10_4

 

Thank you,

 

Wil

4 REPLIES 4
PhilipMannering
16 - Nebula
16 - Nebula

Hi @wcamarg3 

 

Something like this?

PhilipMannering_0-1633355698636.png

 

wcamarg3
8 - Asteroid

Hi @PhilipMannering . I will not work in all situations.

 

If I have another "Checkpoint" or another "NOK" it will not work. 

 

wcamarg3_0-1633355948160.png

 

It should take in consideration the "SN".

 

shreyanshrathod
11 - Bolide

@wcamarg3 

 

See if this helps.

 

Regards,

Shreyansh

wcamarg3
8 - Asteroid

Hi @shreyanshrathod . Unfortunately no.

 

I did the tryout. It doesn't work as desired. For example I put the checkpoint for OP A_102_1. 

 

 

wcamarg3_0-1633357034644.png

 

Labels
Top Solution Authors