Transposing a Unique Value per Group By

cmyer

Hi Alteryx Users,

I currently have a data set the looks like this:

Name Status Time Location

Data 1 Y 12 45

Data 2 Y 14 60

Data 3 Y 14 60

I would like to transpose the first unique value of each group leaving blank spaces in between (not NULLs):

Name Status Time Location Time Ext Location Ext

Data 1 Y 12 45 12 45

Data 1 Y 12 45

Data 2 Y 14 60 14 60

Data 2 Y 14 60

Data 3 Y 14 60

Any Ideas on how I can achieve this?

Workflow

Datasets

Developer

Developer Tools

Regex

Parse

Data Investigation

Accepted answers

Jonathan-Sherman

But you could attach just to the first one by identifying the record and joining to only that record, subsequently unioning all the data back together!

Kind regards,

Jonathan

20211104 - UniqueValuePerGroup.yxmd

All comments

Jonathan-Sherman

Hi @cmyer,

The only way to store the empty cells in Time Ext and Location Ext as empty rather than Null would be to store the fields as a string.

Kind regards,

Jonathan

Jonathan-Sherman

But you could attach just to the first one by identifying the record and joining to only that record, subsequently unioning all the data back together!

Kind regards,

Jonathan

20211104 - UniqueValuePerGroup.yxmd

cmyer

Hi Jonathon

Assuming I left NULLS how can I achieve the transpose?

cmyer

THANKS 🙂

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335