How to use the transformed column in another Table

Ramu
Contributor
June 18, 2024

 

 

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 

 

1 answer

Suggest an answer

Log in or Sign up to answer
1 vote
Ramu
Contributor
June 18, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 19, 2024

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.

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events