https://community.qlik.com/t5/Search-the-Community/Merging-current-file-with-history/m-p/1815566#M370 <P>I think I have a very simple issue.&nbsp; I am using 3 files: 1. fiscal calendar file with date, fiscal Week, fiscal year, fiscal month, 2. Historical file containing company, Inventory, Date, fiscal week, fiscal month, fiscal year and inventory data,&nbsp;3. Current file containing company, Inventory, and Date (being derived from the current filename).&nbsp; I intend to use that date as a look up in the fiscal calendar file to get the fiscal week, fiscal year and fiscal month; build a record matching the historical file layout, append the record and save the file.</P><P>Seems simple to me.&nbsp;I can load the calendar, historical, current file and get the date from the filename but creating the record and storing it just isn't working.&nbsp; I think I understand concatenate but I get 'not found' errors when I try and use the derived date from the filename.&nbsp; I am deriving the date in the load of the current file. I tried naming everything the same so concatenate would just grab the data but clearly I do not fully understand it.&nbsp;&nbsp;</P><P>Any help would be appreciated.&nbsp; Thanks in advance.</P> Wed, 16 Jun 2021 16:19:37 GMT MER 2021-06-16T16:19:37Z https://community.qlik.com/t5/Search-the-Community/Merging-current-file-with-history/m-p/1815566#M370 <P>I think I have a very simple issue.&nbsp; I am using 3 files: 1. fiscal calendar file with date, fiscal Week, fiscal year, fiscal month, 2. Historical file containing company, Inventory, Date, fiscal week, fiscal month, fiscal year and inventory data,&nbsp;3. Current file containing company, Inventory, and Date (being derived from the current filename).&nbsp; I intend to use that date as a look up in the fiscal calendar file to get the fiscal week, fiscal year and fiscal month; build a record matching the historical file layout, append the record and save the file.</P><P>Seems simple to me.&nbsp;I can load the calendar, historical, current file and get the date from the filename but creating the record and storing it just isn't working.&nbsp; I think I understand concatenate but I get 'not found' errors when I try and use the derived date from the filename.&nbsp; I am deriving the date in the load of the current file. I tried naming everything the same so concatenate would just grab the data but clearly I do not fully understand it.&nbsp;&nbsp;</P><P>Any help would be appreciated.&nbsp; Thanks in advance.</P> Wed, 16 Jun 2021 16:19:37 GMT https://community.qlik.com/t5/Search-the-Community/Merging-current-file-with-history/m-p/1815566#M370 MER 2021-06-16T16:19:37Z https://community.qlik.com/t5/Search-the-Community/Merging-current-file-with-history/m-p/1815918#M372 <P>I think renaming the date fields to look alike without any case sensitive would create an automatic connection.&nbsp;</P> Thu, 17 Jun 2021 16:48:49 GMT https://community.qlik.com/t5/Search-the-Community/Merging-current-file-with-history/m-p/1815918#M372 ronith7919 2021-06-17T16:48:49Z