Alteryx Designer Desktop Discussions

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

Data Investigation - expired products & uncompleted

Luk88kk
8 - Asteroid

Hello everyone,
once again I am stuck and need your help.

I am wondering how I can extract all the products for which the expiry date has already passed and for which the data is incomplete. I will have to look at this data later.

 

This is my table with remarks:

Luk88kk_0-1636459051438.png

 

This is the result I would like to achieve:

Luk88kk_1-1636459085731.png

 

I am asking for your help.

 

3 REPLIES 3
Luk88kk
8 - Asteroid

I attach a file:)

carlosteixeira
15 - Aurora
15 - Aurora

Hi @Luk88kk how are you?

 

Follow the workflow to you try.

 

Let me know if this helps.

carlosteixeira_0-1636462098258.png

 

Thanks

 

Carlos A Teixeira
Luk88kk
8 - Asteroid
Thank you very much. Works perfectly. Have a nice day
Labels