topic [resolved] How to check either the file is exist or not in Talend Studio

[resolved] How to check either the file is exist or not

Anonymous — Thu, 24 Nov 2016 01:09:44 GMT

Hi,
I need to check either file is exist or not.
The overall job :

The file is exist, but the result "false".

Setting on tfilelist :

Setting on tfileexist :

If condition :

Thanks

Re: [resolved] How to check either the file is exist or not

vapukov — Thu, 24 Nov 2016 01:25:51 GMT

for what reason You use combination - tFileList -> tFileExists?

tFileList always give You only existed files
if for any reason You use tFileExists
if condition

((Boolean) globalMap.get ("tFileExist_1_EXISTS"))==true

Re: [resolved] How to check either the file is exist or not

Anonymous — Thu, 24 Nov 2016 01:29:25 GMT

if i changed setting on tfileexist to "((String)globalMap.get("tFileList_2_CURRENT_FILEPATH"))" the result will "true".
If the file not exist will get error on tfileexist
[color=#ff6633][FATAL]: dicu_igatev1.test_d_r01_myresults_sppii_vot_code_0_1.TEST_D_R01_MYRESULTS_SPPII_VOT_CODE - tFileExist_1 null[/color]
Exception in component tFileExist_1
java.lang.NullPointerException

Re: [resolved] How to check either the file is exist or not

vapukov — Thu, 24 Nov 2016 10:03:32 GMT

for what are You doing this?
tFileList - not return nothing if no files - it list only what in folder, all files by pattern
tFileExist need ONLY when You want check specific files
for tFileList (if You need if-trigger) - use NB_FILES it will be 0 if nothing or more than 0