Filtering Field and Assigning Values to Adjacent Field

[workinghardly]

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!

[michael_d]

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

[workinghardly]

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

[michael_d]

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

[workinghardly]

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.

[michael_d]

Give this a try, fingers crossed

[workinghardly]

Michael,

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

[michael_d · Accepted solution]

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

Thanks,

Michael

[workinghardly]

Michael,

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

[michael_d]

No problem, happy to help :)