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

Transpose query

PrashantJP
7 - Meteor

Hi Folks,

 

I have a query regarding transpose. I tried it quite a few times but I am unable to get the desired output. Could you please help?

Below is the input:

O/L SLA3-May4-May5-May6-May7-May
 MonTueWedThuFri
Americas     
FIG YYYYY
FundsYYYYY
Hedge FundsYYYYY
CorpNYYYN
RENNNYN
LatamNNNYN
      
EMEA     
FIG YYYYY
CorpYYYYY
EM YYYYY
      
Total67796
      
SLA %67%78%78%100%67%

 

The output should be as follows. Just need Date and SL % to be transposed as below.

DateSLA%
5/3/202167%
5/4/202178%
5/5/202178%
5/6/2021100%
5/7/202167%

 

Appreciate your help!

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @PrashantJP 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1633596318478.png

 

Hope this helps : )

PrashantJP
7 - Meteor

Can you please do the same with attached file?. I am unable to replicate the workflow when I use excel file input

atcodedog05
22 - Nova
22 - Nova

Hi @PrashantJP 

 

Here is the updated workflow

 

atcodedog05_0-1633599689050.png

 

Hope this helps : )

 

Labels