Hi guys, thank you for your help. I want my table 1 to change to table 2. Please make it more dynamic. table 1: Partner or Entity NameProperty NumberNet Depletable BasisCost Depletiontest 1201859429.5test 220241996.91555 table 2: Net Depletable BasisCost DepletionNet Depletable BasisCost Depletionwill have new calculation name if there is in table 1Property Numbertest 1test 1test 2test 2 will have test 3 if table 1 has test 3 201859429.5 202 41996.91555 Thank you so much for your help.

HI Dawn, This is what I needed for my report. and I got this so far 01234Property NumberNet Depletable BasisNet Depletable BasisCost DepletionCost DepletionProperty NumberRight_test1Right_test2test1test2201429.5 859 202 555 41996.9 The only thing that I need to figure out is how to make those Right_test1 and Right_test2 to the same name as test1 and test2. Thank you for your help

Transform Table

ThankForYourHelp

Hi guys, thank you for your help.

I want my table 1 to change to table 2. Please make it more dynamic.

table 1:

Partner or Entity Name	Property Number	Net Depletable Basis	Cost Depletion
test 1	201	859	429.5
test 2	202	41996.91	555

table 2:

	Net Depletable Basis	Cost Depletion	Net Depletable Basis	Cost Depletion	will have new calculation name if there is in table 1
Property Number	test 1	test 1	test 2	test 2	will have test 3 if table 1 has test 3
201	859	429.5
202			41996.91	555

Thank you so much for your help.

Workflow

Developer

Developer Tools

Input

Output

Parse

Transformation

Dynamic Processing

Join

Accepted answers

All comments

cmcclellan

What are you really trying to do ?

If you want to insert the Property Number row you need to make all fields string data type and then you can't (easily) SUM them or anything else

ThankForYourHelp

sorry sir, just changed my logic in the post

ThankForYourHelp

sorry, just changed my logic in the post

cmcclellan

It looks confusing ....

In Table1, 429.5 is the Cost Depletion value for Test 1, Property 201

In Table2, that value has moved to being the Net Depletable Basis value for Test 1, Property 202

Is that right?

Is that what you want to do? (I'm just not understanding the logic you want in the transform)

ThankForYourHelp

I changed my logic in table 2. 429.5 is still the cost depletion value for Test 1, Property 201 in table 2

cmcclellan

OK, that makes more sense

I did this ..

2025-01-31 13_04_45-Alteryx Designer x64 - _New Workflow1.png

crosstab multiple columns.yxzp

ThankForYourHelp

This is good but is there a way to move that net_depletable and cost_depletion on top of that test 1 and test 2 instead put them together? like what I have in table 2

DawnDuong

Hi @ThankForYourHelp

I have replied to your other thread which seems to be related to the issue.

The short question is that you probably can achieve what you set out to do with combinations of Transpose and Crosstabs, as it feels like you are trying to make the column values to be headers and headers values to be column values.

Echoing @cmcclellan point, it's best to revisit and define the objective, i.e. what is needed and why is it needed, rather than focusing on the task of transforming this format to another.

Cheers,
Dawn.

ThankForYourHelp

HI Dawn,

This is what I needed for my report. and I got this so far

0	1	2	3	4
Property Number	Net Depletable Basis	Net Depletable Basis	Cost Depletion	Cost Depletion
Property Number	Right_test1	Right_test2	test1	test2
201	429.5		859
202		555		41996.9

The only thing that I need to figure out is how to make those Right_test1 and Right_test2 to the same name as test1 and test2.

Thank you for your help

lwolfie

Did you ever figure this out? I had something similar that I had to do. I used table tools for the headers and then joined them together with the table. (The data table did not output the header column.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703