Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Merge two row into one row

Highlighted
7 - Meteor

Hi Alteryx Community,

 

How do I solve this problem in alteryx?

 

NameMethodDateMethods
A12020-5-8[Null]
A[Null]2020-5-8 3

 

I want to change it into this.

NameMethodDateMethods
A12020-5-83

 

How should I proceed?

Highlighted
16 - Nebula

Here's one way

 

DavidP_0-1588928403010.png

 

Highlighted
7 - Meteor

I'm sorry actually the data looks like this.

 

terrellchong_0-1588928650635.png

 So if I use summarize, and max, it will go to the 3,3 instead on 1, 3.

 

Is there any method to go around?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @terrellchong I mocked up a worklfow let me know what you think?

Highlighted
7 - Meteor

Yes! This is exactly what I am looking for. Mind if you tell me what you did with the multi-row formula?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @terrellchong I just slightly revised the multi formula tool and attached to my previous message but essentially this checking to see if the column name and value are the same if they are it will make the second row empty so this removed in the filter. 

Labels