Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-06-23 06:01 AM

Excel Formulas not effecting when Data is exported

Hi
I require some help with a Basic Job. I?m importing data from a .cvs file to an excel file. I used tMap to JOIN in the Data.
I used an excel template (TimeSheet_Report_Test.xlsx) with some formulas in it. The Data exports to the excel just fine, but the formulas in the excel do not take effect when the data is exported to the excel file.
Hence the Formulated Columns to not change.
Does someone have a solution for refreshing the formulas in the column so they can take effect on the data?

I'm using File Delimited > tMap > tFileOutputExcel

Labels (2)
Labels
807 Views
0 Likes
10 Replies
Anonymous
Not applicable
‎2016-03-30 04:58 AM
Author

Problem solved. I checked "Recalculate Formula"  https://help.talend.com/search/all?query=tFileOutputExcel&content-lang=en
107 Views
0 Likes