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

Alteryx designer Discussions

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

Need Help for formula

Highlighted
Atom

Hi,

I have data shown below. If last is TRUE or FALSE for Each id i need all the values should be either TRUE or FALSE like shown below.Thanks!

INPUT:

IDFirstLast
ATRUE 
A  
A  
A TRUE
BTRUE 
B  
B TRUE
CTRUE 
C  
C  
C  
C  
C FALSE

 

EXPECTING OUTPUT:

 

IDFirstLast
ATRUETRUE
A TRUE
A TRUE
A TRUE
BTRUETRUE
B TRUE
B TRUE
CTRUEFALSE
C FALSE
C FALSE
C FALSE
C FALSE
C FALSE
Alteryx Certified Partner
Alteryx Certified Partner

Hi!

 

There's a couple of easy solutions for this problem, you can use a filter and join tool, or you can create a 'fill down' using them multirow formula tool.

 

I've attached examples of both.

 

Ben

Alteryx Certified Partner
Alteryx Certified Partner

Hi @swathit 

 

I'd use a very simple Summarize Tool and then join it back to your dataset.

 

example.PNG

 

Cheers,

Quasar

Sample workflow as below. 

 

Need Help for formula-workflow.PNG

Atom

Thank you everyone.

 

Hi,

 

I have data like shown below. I need to subtract the dates for each id and get the number. Can anyone help me for the formula. Thanks!

 

IDDate
A8/23/2018 13:37
A 
A8/23/2018 13:47
A 
B9/28/2018 14:41
B 
B 
B 
B9/28/2018 16:23
C10/1/2018 0:26
C 
C10/11/2018 1:14
Alteryx Certified Partner
Alteryx Certified Partner

Hi @swathit 

 

Do you need to measure the difference of the dates in days?

 

DiffDays.PNG

 

 WF appended.

 

Cheers,

Labels