tfilelist in Talend???????

[ankit7359]

Hi,

I was using tfilelist jus to see the number of excel files i have created and the name of those files... it so happened that i started to observe something in the output...

~$filename.xlsx...

Like why is that i m getting prefix of ~(tilde) and $(dollar).. what does this mean.. also if the excel is open..will it read the file...?????????

Pls help 

Thanks in advance

[Anonymous]

Hi,

     If an excel is open, it will create a temporary file in the same location. Since it is a hidden file, you will not be noticing it from Windows environment. But when you are using a tFileList command, it identifies all the files in a specific directory. This is the reason temp file names are also displaying in your result set.

     You can see these temp files if you activate view hidden files option in Windows.

    If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

[ankit7359]

hi @nthampi,

so you mean to say that the file which are prefixed with ~(tilde) or dollar they are temp files either because they are open or hidden.. also if the files are moved ??? if the files are moved from the current directory... will it also show the result ????

Also ... they are options in tfilelist like ASC and DESC and order by default etc.... 

can you give me a brief overview on this... ?????

thanks in advance...

ankit

[Anonymous · Accepted solution]

@ankit7359

  The temp files related to excel will disappear the moment you close the file using MS excel. 

  You can also selectively pick files based on file mask option available in tFileList component.

   Detailed description of options available and sample scenarios can be viewed from below link from Talend help document.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/VckAFxyC4mToZdOPDrZd8A

Hope I have answered your query. If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi