How to use the transformed column in another Table

[Ramu]

Hey,

I have a manually created Table T1 transformed using Table Transformer to display the 'Name, Salary, Bonus, Total'   ->  out of which the Total Column is defined in Transform logic as :

(T1.Salary + T1.Bonus) as 'Total'

now, i have another Table T2 (Transformed) where i want/need to refer/use this 'Total' column of first Table transformed.

for ex,

my T2 has columns like ' Name, Availability, Billing' ->

here for the 'Billing' column's calculation, i want to use the 'Total' column of first Table ..

we are aware that this cant be done as T1.Total (coz "Total' was a transformed/defined column and not originally the built in column of T1 ..)

So, how to refer the T1's Total column in my T2 calculation/Table ?

i.e., How to call/use the Transformed COLUMN in one Table into the other Table ?

Please help  ..

@Stiltsoft Support

https://community.atlassian.com/t5/user/viewprofilepage/user-id/5062270 

[Ramu]

This is the first time i see that there is no immediate LIKE or response from you for more than a day !! understood that you may be loaded with many queries and engaging ..

Hope one of you will find time to help me on this .. Please

[Stiltsoft support]

Hi @Ramu ,

The Atlassian Community is for sharing user experience, it is not a support portal of our company. We try to search for relevant questions manually (by key words, tags, etc.) but some questions can be missed.

Seems that it's not the first question created by you here and we definitely have already given a link to our support portal. So, here it is once again: https://stiltsoft.atlassian.net/servicedesk/customer/portal/14

Meanwhile, you may check this part of our documentation: https://docs.stiltsoft.com/tfac/cloud/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-Calculatingthecompletionratio

Here we use two SELECTs: internal and external. In the internal SELECT we create the 'Completion Ratio' column and in the external SELECT we refer to this column.

Or you may simply use several Table Transformer macros wrapped one into another. Especially if you have several source tables and need to transform your tables firstly and then combine them.