The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!

Jump to content

How to transform data after calculated columns based raw data from two sources

cloud integration

By Valerine Tng
October 22, 2020 in Integration

Share

https://community.tibco.com/forums/topic/10005-how-to-transform-data-after-calculated-columns-based-raw-data-from-two-sources/

Followers 0

Recommended Posts

Valerine Tng

Posted October 22, 2020

Hi,

What I am trying to do:

1. Add calculated columns in Sheet 2 into Sheet 1

2. Add calculated columns based on Sheet 1 and 2 combined output

3. Transform data based on output in Step 2.

However I find that I cannot transform the data based on the calculated columns in 2. I could only transform the data based on Sheet 1 and 2 raw data.

Can you advise how I can go about doing step 3