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,
Solved! Go to Solution.
Hi @messi007,
No need for a macro, you can solve this with a few Transform tools and one Multi-Row formula:
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,