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.

[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 .. 

 

[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

[cmcclellan]

If you want a report you might be able to do that, but Alteryx tends to work as if it's a database table, so you can't have a 2 line header like that .... (as I said before) that would make all those columns a string data type and that will lead to problems later.

[ThankForYourHelp]

theres a way to do it. I just don't know how. thank you for your help.