https://community.qlik.com/t5/Talend-Studio/Calculated-field-on-a-fact-table/m-p/2370505#M133539 <P>I want to calculate age based on current date and load that into fact table. However my fact is not truncate and reload. It is incremental. In Tmap i cannot do that as it will try to insert daily based on change in current date. Is global variable my only option?</P> Fri, 15 Nov 2024 23:38:51 GMT Ameyy 2024-11-15T23:38:51Z https://community.qlik.com/t5/Talend-Studio/Calculated-field-on-a-fact-table/m-p/2370505#M133539 <P>I want to calculate age based on current date and load that into fact table. However my fact is not truncate and reload. It is incremental. In Tmap i cannot do that as it will try to insert daily based on change in current date. Is global variable my only option?</P> Fri, 15 Nov 2024 23:38:51 GMT https://community.qlik.com/t5/Talend-Studio/Calculated-field-on-a-fact-table/m-p/2370505#M133539 Ameyy 2024-11-15T23:38:51Z https://community.qlik.com/t5/Talend-Studio/Calculated-field-on-a-fact-table/m-p/2370506#M133540 <P>Hi </P><P>Can you describe your case with some example data? What are your expected result?</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Fri, 08 Oct 2021 02:16:03 GMT https://community.qlik.com/t5/Talend-Studio/Calculated-field-on-a-fact-table/m-p/2370506#M133540 Anonymous 2021-10-08T02:16:03Z