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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] unable to count file row count

Hello,
I have a job which captures all details of the files in a particular folder.Like file_rowcount , size or file_name,
But i am unable to capture file_rowcount
Please see my job designe:-

0683p000009MCUq.png

tfilelist:-
0683p000009MChq.png
tfileproperties:

0683p000009MChq.png
tfilerowcount:-
0683p000009MCnW.png
tmap:
0683p000009MCpl.png
the output i am getting correct except count is not matching with the file , its giving any random xyz figure.
Please help here
Thanks.
Labels (2)
12 Replies
Anonymous
Not applicable
Author

Hi
There is a global variable that counts the total number of files are found in the directory.
((Integer)globalMap.get("tFileList_1_NB_FILE"))
Regards
Shong
Anonymous
Not applicable
Author

Hi
There is a global variable that counts the total number of files are found in the directory.
((Integer)globalMap.get("tFileList_1_NB_FILE"))
Regards
Shong

Dear Shong,
I used the same global variable , but its giving me sequence number for every row.
ex: if there are 40 files in the folder . 
it will give me sequence 
1
2
3
4.
.
.
.till 40
I want 40 to display to every where instead of sequence.
Anonymous
Not applicable
Author

Where do you use this global variable? It should be used in next subjob if you want to get the total number of files, eg:
tfilelist--iterate...
   |
onsubjobok
   |
tjava
on tJava, print the value of this global variable.