FTP FILE EXISTS-DOES NOT WORK

Hi everyone, I am working with ftp on file zilla, I want to download files to my local folder, I already have the activity for file exists and to download files to my local path but now the issue is in the path where there are files, it says no files exists even if there are there:
The naming of the file is like this
image
The only thing that is dynamic is the date after ‘Sales’ where I had put ‘var’.

Everything else there is the same.
The name of the file is like this: Cellular Device Sales 1feb-30Mar.xlsx

Hi @Anelisa_Bolosha1

Can you specify what does the var variable contain.

May be try passing the below way:

"TobeProcessed/Cellular Device Sales"+var+".xlsx"

Regards

1 Like

Hi,

I believe “Var” is the variable which you used to store the date value. If it is so , the path should be “TobeProcessed/Cellular Device Sales”+Var+“.xlsx” .

1 Like

@Anelisa_Bolosha1

The use of var looks wrong…the way you gave ,it is considered as string and not as variable

Try "stringvalue" + var + "stringvaleu"

Also not sure if youa re avle to calculate the exact value…one more way is to get the files and chceck if the name matches…enumerate objects activity will help in it

Cheers

1 Like

‘var’ is a date which is dynamic because sometimes it’s another date,when the file is uploaded only the date changes
e.g. Cellular Device Sales 1feb-30Mar.xlsx

Hi @Anelisa_Bolosha1

Try passing below way:

"TobeProcessed/Cellular Device Sales "+var+".xlsx"

Regards

I want to assign this variable ‘var’ as dynamic because it’s changing, how do I do it?

@Anelisa_Bolosha1

what is the period of month you want to store is it like start Date of a present month and end Date of the present month in the var.

Regards

image
The dates change

Hi @Anelisa_Bolosha1

Since the dates aren’t within a month, you can’t make this dynamic. Are if there are specific dates like start of present month and end of present month it will be fine. But the dates are specific in the given picture

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.