Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Find and replace not providing correct output

Amy123
8 - Asteroid

Hi Team,

 

Can someone help me to bring the status on the find status column.

ReplaceSegmentOrder NumberConcatenate Order +SegmentBalanceStatus
 1234 1234_50000Open
 1234 1234_-232Closed
      
      
Find Segment Order NumberConcatenate Order +SegmentBalanceStatus
 1234 1234_15000 
 1234 1234_15000 
 1234 1234_20000 
 1234 1234_-100 
 1234 1234_-100 
 1234 1234_-32 
1 REPLY 1
dhavaldoshi
8 - Asteroid

Hi Amy,

 

What are you trying to use as the key, if it is Segment or Concatenate Order + Segment, it will not be able to decide whether it should show Open or Closed, and will show whichever is the first line i.e. Open in this case.

 

I would rather use a Join tool with multiple join parameters

 

Labels