Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get file name from tfilelist

How to get file names, size, row count and send it to email by using Java components or can we achieve without java components

Labels (3)
22 Replies
Anonymous
Not applicable
Author

I want to append all the files and need to send email

Anonymous
Not applicable
Author

I want to append all the files and need to send email
Anonymous
Not applicable
Author

Have you tried reproducing the job that @vaibsVB suggested? If not, do that first. If so, replace the tJavaRow code with mine (after configuring a new context variable for Message) and see what you get.

Anonymous
Not applicable
Author

I got the solution thanks for support

Anonymous
Not applicable
Author

Can you tell us what you did so that others can benefit from this question in the future?

Anonymous
Not applicable
Author

I have followed the above one @vaibsVB's model and gave your context.email(message) in tjavarow it is working 

vaibs_parab
Contributor II
Contributor II

Sorry for reaching late.

 

@im_arod Glad part of my solution work for you.

@rhall Thanks for giving inputs.

 

In order to get all files from the folder, I tried another approach try this if it works for you.

And also suggest improvements also.

 

0683p000009LyZV.jpg

 

tFileList_3 and tFileProperties_2 settings are same as previous example.

At tIterateToFlow_1 here are the settings:

0683p000009LyZa.jpg

 

At tDenormalize_1 here are the settings:

0683p000009LyWc.jpg

Make note, in above Delimiter setting I purposefully kept the ", ".

 

And you will get desired output i.e. FileNames from the folder in list format. You can store this filename list into context and use in Mail Component.

 

Regards.

Anonymous
Not applicable
Author

Hi I tried the same but while compiling the job found errors in file row count it specified that string is undefined
Anonymous
Not applicable
Author

Hi I tried the same but it showing error as undefined string in tFilerowcount and tjavarow
Anonymous
Not applicable
Author

Hi i tried the same design  but got below error could some one help me i am new to this tool. Attaching the screen shots0683p000009M5wS.jpg0683p000009M5pc.jpg