Alteryx Designer Discussions

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

Multiple values within one column to be copied into another existing column

Dark5tar
6 - Meteoroid

Hello, i am bringing a couple of simialr files to geehr but in one area thy differ crucicially; one file shows the line item age as an number, whilst the other file shows the aged of the line item by placing it within one the age bucket columns.

how can i bring the files togther so that the single column age is represented in the appropriate existing bucket columns?

 

CURRENT INPUT
 AGE<1day<2days3-5days6-10days11-15days>115days
Line item 110      
Line Item 2  1    
        
ENDEAVOUR
 AGE<1day<2days3-5days6-10days11-15days>115days
Line item 110   1  
Line Item 2  1    
3 REPLIES 3
atcodedog05
21 - Polaris

Hi @Dark5tar 

 

Here is how you can do it. Create formula for each and flag the value.


Workflow:

atcodedog05_1-1642178029457.png

 

Hope this helps : )

 

Dark5tar
6 - Meteoroid

think i was over thinking it - perfect thanks

atcodedog05
21 - Polaris

Happy to help : ) @Dark5tar 

Cheers and have a nice day!

Labels