topic Multiple values within one column to be copied into another existing column in Alteryx Designer Desktop Discussions

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

Dark5tar — Fri, 14 Jan 2022 16:13:51 GMT

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	<2days	3-5days	6-10days	11-15days	>115days
Line item 1	10
Line Item 2			1

ENDEAVOUR
	AGE	<1day	<2days	3-5days	6-10days	11-15days	>115days
Line item 1	10				1
Line Item 2			1

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

atcodedog05 — Fri, 14 Jan 2022 16:38:48 GMT

Hi @Dark5tar

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

Workflow:

Hope this helps : )

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

Dark5tar — Wed, 19 Jan 2022 20:15:09 GMT

think i was over thinking it - perfect thanks

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

atcodedog05 — Thu, 20 Jan 2022 06:48:51 GMT

Happy to help : ) @Dark5tar

Cheers and have a nice day!