community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Filtering Field and Assigning Values to Adjacent Field

Meteoroid

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.  

FormulaPopulateAmount
1 1410
0 2110
1 1600
1 1880
1  
0  
1  
0  
1  
1  
1  
1  
0  
1  

 

The end stating looking like this:

FormulaPopulateAmount
1  
01410 
1  
1  
1  
02110 
1  
01600 
1  
1  
1  
1  
01880 
1  

 

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

 

Thank you!

Asteroid

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

Meteoroid

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

Asteroid

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

Meteoroid

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.

 

Asteroid

Give this a try, fingers crossed

Meteoroid

Michael,

 

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

Highlighted
Asteroid

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

 

Thanks,

 

Michael

Meteoroid

Michael,

 

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

Asteroid

No problem, happy to help :)

Labels