Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Formula Language Help

Highlighted
5 - Atom

Hi -

 

I need some help with filtering/using a formula to ignore data on some occasions.I am trying to only pull data for the date if the code for type as changed for the particular key value.

NameTableFieldKey
Typetable1Code9300
Datetable1Date9300
Typetable1Code4500
Datetable1Date4500

Any help would be appreciated!!

Highlighted
9 - Comet

Hello,

 

Could you post some sample data that includes a case of where you would like the data pulled?

Highlighted
5 - Atom

Thank you for your reply! Here is a little more info:

 

So I only want to pull the start date information when the status for the same key differs in Field1 and Field2. In the below example I would only want to pull the Start Date and Status for key 9300 because the status differed in Field1 and Field2.

 

NameTable Field1KeyField2
Statustable1A9300B
Start Datetable11/1/2019930012/1/2018
Timetable1Active4500Active
Start Datetable11/1/20194500

12/1/2018

 

 

 

 Let me know if I can provide more information. Thanks!!

Highlighted
9 - Comet

Does this work?

Labels