Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
Free Trial

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
Top Solution Authors