Free Trial

Alteryx Designer Desktop Discussions

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

Remove null values

hcho2
5 - Atom

How can I transform data from this:

A1B1
A11 
A12 
A13 
A14 
 B11
 B12
 B13
 B14

 

To this?

A1B1
A11B11
A12B12
A13B13
A14B14
3 REPLIES 3
OTrieger
12 - Quasar

@hcho2 

Hard to say from only looking on your post, if you can elaborate ,more on how the macro works, what is the input data in each Macro input and what the macro does.

hcho2
5 - Atom

I realized manipulating batch macro is overly complicating the problem. I just revised the question so that it dealing simpler concept! Thanks for pointing that out.

EKasminsky
7 - Meteor

Filter column A1 as !IsNull([A1]) as group 1, Filter column B1 as !IsNull([B1]) as group 2, Join on Record Position and rename right join B1 from Right_B1

Labels
Top Solution Authors