Here's the existing flow in my job.
DB --> tMap --> OutputExcel
Once the data gets in to the excel (Column A to Column X will be filled), the formula in Column-Y and Column-Z will be calculated.
Now, I want this calculated data also move back to DB. In this case, the excel data which moves back to DB is from the Column-A to Column-Z.
Please suggest the solution to achieve it.
Solved! Go to Solution.
@samisyed80,in tmap,you can populate in output shcema,with two extra coulmns.as shown below.
Thanks Manohar, actually the calculation is happening in excel. After calculation i need to grab those values and send it back to DB. In this case, how can i pull only the calculated value? Example:- if the result is 15 for the excel formula "=A+B" then i need to send the value 15 to DB. Please suggest
current flow is
Is the below flow i should follow?
@samisyed80,yes you can do the below way.
actually the calculation is happening in excel. After calculation i need to grab those values and send it back to DB. In this case, how can i pull only the calculated value? i don't want the calculation part to be inserted in talend, but i need only the calculated value.
@samisyed80,you can check the caluculated value is greated than 0 you can populated to DB in tMap itself.
see the flow and formula. I need to grab the value from "Denominator and Numerator" column to DB. Output is not yet placed, but before output DB i have placed a tMap. See the screenshot. Is this fine? I still don't get how the calculated value will come here.
If i understand correctly, first you need to load records to excel file and excel will calculate to columns by using formula. Now you need to read all populated columns from excel and two calculated fields as well correct?
If yes, The first load excel file with a-x columns and then use target excel as source.Now in source include y,z columns as well. Use target as DB table and update new columns based on key column (if you have ) else insert all columns into target DB.
hope this helps!
Yes Veeru, you understanding is right. This is what i want. Thanks for your suggestion. I will do it that way.
@samisyed80,may be you were getting null pointer exception for other coulmns not to these.can you check?
Join us live for a sneak peek!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.