topic Re: Filtering Field and Assigning Values to Adjacent Field in Alteryx Designer Desktop Discussions

Filtering Field and Assigning Values to Adjacent Field

workinghardly — Thu, 24 May 2018 04:34:08 GMT

Hi,

I am trying to figure out how to assign the Amount values to the Populate field, next to the 0's. Starting from the first value in Amount and continuing down, top to bottom.

Formula	Populate	Amount
1		1410
0		2110
1		1600
1		1880
1
0
1
0
1
1
1
1
0
1

The end stating looking like this:

Formula	Populate	Amount
1
0	1410
1
1
1
0	2110
1
0	1600
1
1
1
1
0	1880
1

Is this possible? I hope that the question makes sense. As I write it, I am confusing myself.

Thank you!

Re: Filtering Field and Assigning Values to Adjacent Field

michael_d — Tue, 05 Dec 2017 14:55:01 GMT

Hi workinghardly,

Here's a quick fix for you, it should hopefully work for you based on what I understand from your query. Any questions are welcome.

Thanks,

Michael

Re: Filtering Field and Assigning Values to Adjacent Field

workinghardly — Tue, 05 Dec 2017 15:21:24 GMT

Apparently I am using an older version of Alteryx so I was not able to open your workflow :(

Re: Filtering Field and Assigning Values to Adjacent Field

michael_d — Tue, 05 Dec 2017 15:50:30 GMT

Which version are you running? Have a look here...

https://community.alteryx.com/t5/tkb/articleprintpage/tkb-id/knowledgebase/article-id/854

If you aren't comfortable doing it yourself I can still try and fix it for you :)

Thanks,

Michael

Re: Filtering Field and Assigning Values to Adjacent Field

workinghardly — Tue, 05 Dec 2017 15:55:31 GMT

Hey Michael,

I am using version 10.6.8. My team has earlier workflows that were not working on the latest version so we stuck with this one, unfortunately.

Re: Filtering Field and Assigning Values to Adjacent Field

michael_d — Tue, 05 Dec 2017 16:01:31 GMT

Give this a try, fingers crossed

Re: Filtering Field and Assigning Values to Adjacent Field

workinghardly — Tue, 05 Dec 2017 16:07:17 GMT

Michael,

Receiving the same error, 'document created by more recent version' :(. Any chance on a screenshot and I can try and mimic it?

Re: Filtering Field and Assigning Values to Adjacent Field

michael_d — Tue, 05 Dec 2017 16:20:07 GMT

Here you go, hopefully it's easily understandable and makes sense, I've annotated where I can :)

Thanks,

Michael

Re: Filtering Field and Assigning Values to Adjacent Field

workinghardly — Tue, 05 Dec 2017 18:52:21 GMT

Michael,

Thanks so much! Made complete sense and I was able to work through it on my larger file. Appreciate the guidance!

Re: Filtering Field and Assigning Values to Adjacent Field

michael_d — Wed, 06 Dec 2017 08:45:08 GMT

No problem, happy to help :)