Alteryx Designer Discussions

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

Batch on multi row formula

messi007
15 - Aurora

Dear Alteryx Comunity,

 

what i have  an input like this

 

F1F2F3
ABCDEFXYZ
NullNullNull
NullNullNull
NullNullNull

 

What I expect to have is this:

 

F1F2F3
ABCDEFXYZ
ABCDEFXYZ
ABCDEFXYZ
ABCDEFXYZ

 

 

What I have done is batch macro in order to batch on multirow formula

 

Batch.PNG

 

I call my batch like this

 

 

CallBatch.PNG

 

but it's creating the same set on each batch what I don't like what expect is:

 

F1F2F3
ABCDEFXYZ
ABCDEFXYZ
ABCDEFXYZ
ABCDEFXYZ

 

 

Attached the ziped workflow.

 

Many thanks in advance for help 🙂

 

Regards,

 

4 REPLIES 4
Aaron_Harter
11 - Bolide

Hi @messi007

 

No need for a macro, you can solve this with a few Transform tools and one Multi-Row formula:

1.PNG 

messi007
15 - Aurora

Thanks @Aaron_Harter,

 

It's good however image if I have a column like this:

 

F1F2F3F4
abcdefxysNull
NullNullNullNull
NullNullNullNull

 

With your process I will get this which is not good:

 

F1F2F3F4
abcdefxysxys
defdefxysxys
defdefxysxys

 

what I shared is just a simple but my dataset have around 22 coulmns with some column are totally Null.

 

Thanks again 🙂

 

Regards,

 

 

Aaron_Harter
11 - Bolide

@messi007

 

To prevent filling down across different fields, check the Group By box for [Name]:

2.PNG 

messi007
15 - Aurora

@Aaron_Harter ,

 

You have been really helpful 🙂

 

Thanks a lot,

Regards

Labels