community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Formula Language Help

Highlighted
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!!

Asteroid

Hello,

 

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

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!!

Asteroid

Does this work?

Labels