Alteryx Designer Desktop Discussions

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

Transforming Certain Rows to Columns

NOLA_Max
6 - Meteoroid

The attached csv has 2 data series in it (Results.series.0.seriesID = LNS11300062 and Results.series.1.seriesID = LNS11000000) along with associated year, month, and value. I am trying to arrange the data such that the columns are:

 

SeriesID | Year | Month | Value

 

I've tried Transpose and Crosstab but just can't figure it our. Thank you for any help.

2 REPLIES 2
Raj
16 - Nebula

Solution!

binuacs
21 - Polaris

@NOLA_Max One way of doing this

 

binuacs_5-1678172008552.png

 

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels