Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Convert sequential vertical data (rows) into horizontal data (columns)

Jes
8 - Asteroid

I have a dataset that lists company name, stock ticker, stock price & currency in a vertical manner & combine the transformed result with another table that contains column headings.

 

Question 1: I'd like to convert the table so that it looks horizontal as seen below. I've tried using the Cross Tab & Summarize tool but was not able to get the result that I was looking for.

 

Before Transformation

Apple1
AAPL2
130.63
USD4
Google1
GOOGL 2
2116.443
USD4

 

After Transformation

1234
AppleAAPL130.6USD
GoogleGOOGL2116.44USD

 

Question 2: Once the table is converted in a horizontal manner, I am planning on appending the 'After Transformation' table to another table that contains the actual column headings. I have not tried this yet because I'm trying to resolve Q1 but if you have a different approach, please let me know.

 

Column Headings

CompanyNameTickerPriceCurrency
1 REPLY 1
randreag
11 - Bolide

hi @Jes 

 

Here i attached an example that answers your questions

 

let me know if you have any more questions

Labels