Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Best way to generate multiples rows

Hakimipous
10 - Fireball

Hello again!

 

I would liek to ask to community if there is a better way (I guess there is) to deal with a certain situation while cleaning data.

 

Here is an exemple of my case :

 

I have a table looking like this :

 

F1F2Employee
Start date01-01-2016Marc
Country of OriginUSMarc
Family situationSingleMarc

 

And what I want it to look like in the end is like this

EmployeeStart DateCountry of OriginFamily Situation
Marc01-01-2016USSingle
Olivier02-01-2015CanadaMarried
....   

 

 

 

The way I use to achieve this is by creating a new field with a formula tool ( looking like : 

IF [F1] = "Start date"
THEN [F2]
ELSE ""
ENDIF 

and repeating this for all the data in F1, and then taking an another step to align the data.

 

It works! but this really is time consuming, 

 

So I was wondering if anyone would have a tips to achieve the result I want faster. 

 

Thanks again !

2 REPLIES 2
danrh
13 - Pulsar

The Cross Tab tool is what you're looking for:

 

image.png

Group by the Employee, use F1 as your headers and F2 as your values.

Hakimipous
10 - Fireball

amazing and simple indeed ! 

 

I tried it before but I see where I was wrong

 

Thanks!

Labels