Help !

[ramarora1985]

This query was posted by one of the user@nexbelgium.

Being Fresher and new to Alteryx I was  just trying to practice the same :

Is there any way that we can obtain the solution without using multi row formula option.. The only solution given contains multi row formula which is been attached below

Hi,

I would like to combine records that I receive in multiple rows into one row.

In short, this is my input:

UserName	Michael
Status	Active
Team	Sales
Location	France
UserName	Thomas
Status	Not Active
Team	HR
Location	Belgium
UserName	Bob
Status	Active
Team	HR
Location	Spain

And this is the what I would like as output:

UserName	Status	Team	Location
Michael	Active	Sales	France
Thomas	Not Active	HR	Belgium
Bob	Active	HR	Spain

Appreciating support 

Regards

[ramarora1985]

Hi,

I would like to combine records that I receive in multiple rows into one row.

In short, this is my input:

UserName	Michael
Status	Active
Team	Sales
Location	France
UserName	Thomas
Status	Not Active
Team	HR
Location	Belgium
UserName	Bob
Status	Active
Team	HR
Location	Spain

And this is the what I would like as output:

UserName	Status	Team	Location
Michael	Active	Sales	France
Thomas	Not Active	HR	Belgium
Bob	Active	HR	Spain

Appreciating support 

Regards

[BrandonB]

Here is an alternative approach using a formula tool to create a flag indicator, a running total tool, and a crosstab. 

 

[grazitti_sapna]

HI @ramarora1985 , try this.

Thanks.

[paulfound · Accepted solution]

Hi @ramarora1985 

Here is another solution using the tile tool.

Ultimately you can do this a few different ways.

Don't forget to mark as complete if your question is answered.  

[ramarora1985]

Thanks PaulFound ; 

Appreciating your support.

Kind Regards

[ramarora1985]

Thanks  grazitti_sapna,

Appreciate your support.

Kind Regards