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

How to change the row into columns back

Sshasnk
8 - Asteroid

First I have a dataset, below one which is the initial dataset  now I transposed the value by grouping by Investment, Fund and Fund id

Before the transpose of the data:

 

FundsellbuypurchaseCancelInvestmentFund Id
ABC148145489159100154
ABC045801590154
ABC8961480159100154

 

now I transposed the value by grouping by Investment, Fund, and Fund id with three transpose tool and union it back to one

Input:

 

FundNamevalueselectionnumber idFund idInvestment
ABCBuy1451 154100
ABCBuy458 31540
ABCBuy148 8154100
ABCCancel159  154100
ABCCancel159  1540
ABCCancel159  154100
ABCPurchase489  154100
ABCPurchase0 5154100
ABCPurchase01 1540
ABCSell1481 154100
ABCSell0  1540
ABCSell896  154100

 

The above table is transposed data and I performed a few calculations and added two columns selection and number id, now I want to reverse it back with the new columns opposite to

Output:

FundsellbuypurchaseCancelselection_sellselection_buyselection_purchaseselection_cancelnumber_sellnumber_buynumber_purchasenumber_cancelInvestmen
ABC14814548915911      100
ABC04580159  1  3  0
ABC8961480159     85 100
1 REPLY 1
binuacs
20 - Arcturus

@Sshasnk One way of doing this

 

binuacs_0-1668206435871.png

 

Labels