Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

filling specific cells

TiffanyH12
7 - Meteor

I want to be able to fill the third column based on what's showing before it.

There are more fields besides what's shown here. And the number of blanks in between vary. It can have 3 spaces to fill or none.

 

this is what I have:

 

Company

F1AM0001
CompanyF2 
CompanyF3 
CompanyF4 
CompanyF51
CompanyF6 
Company

F7

 
CompanyF870
CompanyF9 

 

What I want:

Company

F1AM0001
CompanyF2AM0001
CompanyF3AM0001
CompanyF4AM0001
CompanyF51
CompanyF61
Company

F7

1
CompanyF870
CompanyF970
2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @TiffanyH12 I mocked up a workflow that produces the output you describe. Let me know what you think?

 

Multi_Row_22072020.PNG

TiffanyH12
7 - Meteor

This did exactly what I needed, thank you!

Labels