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

Transposing Data Set

Masond3
8 - Asteroid

Afternoon Alteryx Community 

Hope you can help me or put me in the right direction 

Version : Alteryx Designer 20019. 19.3 X64

I have an CSV input file, that has following 4 column headers; 

Instance IdQuestion IdQuestionAnswer

 


First Step,

  • Order by Instance Id
  • Order by Question id 

From here i am only Interested in a particular set of questions id.

 

The question ids i am interested in are

 

Question IdQuestion
3Billing Address Line 1
4Billing Address Line 2
5Billing Address Line 3
6Billing Address City
7Billing Address Country
8Billing Address State/County/Province
9Billing Address Postal Code
548Billing Name

 

For these static questions id,  i would Like to create these Question as a header on a new excel tab.

Example header Output 

 

Instance IdBilling Address Line 1Billing Address Line 2Billing Address Line 3Billing Address CityBilling Address CountryBilling Address State/County/ProvinceBilling Address Postal CodeBilling Name

 

For a given Instance Id i would like the corresponding answer for the questions above to map back to the relevant header 

Dummy Data 

Instance IdQuestion IdQuestionAnswer
111113Billing Address Line 1123 High Street
111114Billing Address Line 2 
111115Billing Address Line 3 
111116Billing Address CityLondon
111117Billing Address CountryUK
111118Billing Address State/County/ProvinceLondon
11111548Billing NameVodaPhone PLC
111119Billing Address Postal CodeEC1 1AA

 

Expected Outcome 

 

Instance IdBilling Address Line 1Billing Address Line 2Billing Address Line 3Billing Address CityBilling Address CountryBilling Address State/County/ProvinceBilling Address Postal CodeBilling Name
11111123 High Street  LondonUKLondonEC1 1AAVodaPhone PLC

 

Looking forward to your Help 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Masond3 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605287285829.png

 

Workflow:

atcodedog05_0-1605287473784.png

 

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

messi007
15 - Aurora
15 - Aurora

dear @Masond3 

 

please see below:

 

messi007_0-1605287581947.png

Hope that helps 🙂

Regards

Labels