Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

get date from file name

Hi,
I am unable to get Date from a file name to use in tmap expression editor.
Attached is my Job design and tMap editor view. 
1) The tFileRowCount input file name is like "Data_f.cat.fy16.detail.201602.txt". Now I need to read the date part which is "201602" in this case (YYYYMM) and pass it to the "ExtractDate" expression in the tMap expression editor on the output file. For now I've hardcoded "ExtractDate=201602" as you can see in the attached image, but as per the requirement it should read the date from the actual date file name, which is given as input for tFileRowCount in the current job.
2) Is there any way to achieve with and/or without tJava related components
Let me know if I am not very clear about the requirement.

thank you for your time.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Best regards
Sabrina
0683p000009MHGX.png