Alteryx designer Discussions

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

Summarize the dataset

Highlighted
Asteroid

Dear All, 

please help me with this-

I have an input file like this with multiple lines, i need to summarize them like the output i have provided down-

 

 

input data -

A   |B  |    D |  E

1    K             Z

1    K      X

1    K      Y

2    M     

2    M      P

2    M            Q

2    M

3    S

Output data-

A    B      D      E

1    K      X       Z

1    K      Y  

2    M      P       Q

3    S

Alteryx
Alteryx

Hi @Ekta

 

I have attached a workflow that should do what you have requested.

Please give it a try and get back to me.

 

Dan

Highlighted
Asteroid

Thank you so much, worked perfectly fine.

Labels