Batch on multi row formula

[messi007]

Dear Alteryx Comunity,

what i have  an input like this

F1	F2	F3
ABC	DEF	XYZ
Null	Null	Null
Null	Null	Null
Null	Null	Null

What I expect to have is this:

F1	F2	F3
ABC	DEF	XYZ
ABC	DEF	XYZ
ABC	DEF	XYZ
ABC	DEF	XYZ

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

I call my batch like this

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

F1	F2	F3
ABC	DEF	XYZ
ABC	DEF	XYZ
ABC	DEF	XYZ
ABC	DEF	XYZ

Attached the ziped workflow.

Many thanks in advance for help 🙂

Regards,

[Aaron_Harter]

Hi @messi007, 

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

 

[messi007]

Thanks @Aaron_Harter,

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

F1	F2	F3	F4
abc	def	xys	Null
Null	Null	Null	Null
Null	Null	Null	Null

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

F1	F2	F3	F4
abc	def	xys	xys
def	def	xys	xys
def	def	xys	xys

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 · Accepted solution]

@messi007, 

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

 

[messi007]

@Aaron_Harter ,

You have been really helpful 🙂

Thanks a lot,

Regards