https://community.qlik.com/t5/Talend-Studio/Load-Data-into-database-from-file-and-attach-filename-in-a/m-p/2226606#M18458 <P>Hi All,</P> <P>&nbsp;</P> <P>I have a batch job which currently loads data from a list of files into a MySQL table. I'm trying to work out how to use tfileproperties to obtain the filename and attach it as an extra column to the exiting dataset via tmap?</P> <P>&nbsp;</P> <P>Below is my current job which works. But not sure where to add in tfileproperties?</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="test.PNG" style="width: 712px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6JU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152523iED6F27CE083D5C30/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6JU.png" alt="0683p000009M6JU.png" /></span></SPAN></P> Sat, 16 Nov 2024 05:18:10 GMT DavidETL 2024-11-16T05:18:10Z https://community.qlik.com/t5/Talend-Studio/Load-Data-into-database-from-file-and-attach-filename-in-a/m-p/2226606#M18458 <P>Hi All,</P> <P>&nbsp;</P> <P>I have a batch job which currently loads data from a list of files into a MySQL table. I'm trying to work out how to use tfileproperties to obtain the filename and attach it as an extra column to the exiting dataset via tmap?</P> <P>&nbsp;</P> <P>Below is my current job which works. But not sure where to add in tfileproperties?</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="test.PNG" style="width: 712px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6JU.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152523iED6F27CE083D5C30/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6JU.png" alt="0683p000009M6JU.png" /></span></SPAN></P> Sat, 16 Nov 2024 05:18:10 GMT https://community.qlik.com/t5/Talend-Studio/Load-Data-into-database-from-file-and-attach-filename-in-a/m-p/2226606#M18458 DavidETL 2024-11-16T05:18:10Z https://community.qlik.com/t5/Talend-Studio/Load-Data-into-database-from-file-and-attach-filename-in-a/m-p/2226607#M18459 <P>Hello,</P> <P>You can get tFileProperties through iteration of tFileList and use the CURRENT_FILE globalMap value.</P> <P>Best regards</P> <P>Sabrina</P> Wed, 24 Jul 2019 10:16:14 GMT https://community.qlik.com/t5/Talend-Studio/Load-Data-into-database-from-file-and-attach-filename-in-a/m-p/2226607#M18459 Anonymous 2019-07-24T10:16:14Z