Multi field Formula

[Ekta]

Hello everyone 

i would like to seek help on multi field tool.

I have a data set with multiple fields and i would like to autofill the down rows with the above data ,

I have been using multi row formula tool quite well if i have to auto fill 1 or 2 columns but now i have around 20 columns, 

I understand Multi field formula can work in this situation.

Please help me with the formula

Currently am using this formula for one column, how can i modify it for multiple columns

if isempty([Name]) then [Row-1:Name]
else [Name]
endif

Thank you so much

[fmvizcaino · Accepted solution]

Hi @Ekta ,

You are correct to think that multi-field can help you when you want to change multiple columns at the same time.

The only problem is that multi-field tool can't operate between rows as multi-row tool does, so to achieve the result you need, we can do a trick with data transformation to get exactly what you want.

Take a look and let me know if that is what you are looking for.

Best,

Fernando Vizcaino

[danilang · Accepted solution]

Hi @Ekta 

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Thank you!

Dan

[Ekta]

@fmvizcaino 

Thanks a lot for the solution. i tried it and it is working perfectly fine.

Thanks much 🙂

[Ekta]

@danilang This solution works perfectly fine for my case, Thanks a lot:)