Extracting filename from data loading activity | Community
Skip to main content
A
ankurm40172185
Level 2
March 13, 2018
Solved

Extracting filename from data loading activity

  • March 13, 2018
  • 5 replies
  • 5501 views

Hi

I know that we can refer to vars.filename in a data loading activity to find the file name. However; this is uploaded filename and not the one listed in the parameters, plus this is mf5 hashed. How can we find out the actual file name which was used; and record this?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by florentlb

    Hi Ankur,

    I'm not sure if there are ways to find back the original name. I'd recommend checking with support if there is a solution that can be put in place for that.

    Florent

    5 replies

    Amit_Kumar
    Amit_Kumar
    Level 10
    March 14, 2018

    Hi Ankur,

    it's not very clear from your question what you want. can you share the workflow and highlight what you need?

    are you uploading file resources or some csv file?

    regards,

    Amit

      A
      ankurm40172185Author
      Level 2
      March 19, 2018

      Hi Amit

      I want to refer to the name of csv file being loaded in the data load activity; when i use vars.filename it refers to the name of the file after server upload (md5 hashed); is there a system variable which can be used to refer the actual csv file's name.

      florentlb
      florentlbAccepted solution
      Level 10
      April 18, 2018

      Hi Ankur,

      I'm not sure if there are ways to find back the original name. I'd recommend checking with support if there is a solution that can be put in place for that.

      Florent

      florentlb
      florentlb
      Level 10
      May 9, 2018

      Hello Ankur,

      Were you able to get an answer?

      Florent

      A
      ankurm40172185Author
      Level 2
      May 15, 2018

      Yes; we wrote a script on the ftp activity and the next activity to pick and then chop the filename

      S
      Shivam97
      February 3, 2024

      Can you please share the script and let me know how to fetch the original file name instead of server file name (Ex : my file name is file234.csv and after uploading to server it says 1dfghyh45jlkdhsa.csv?) but I need file234.csv as file name. When I'm getting file from server it works alright but with manual loading it changes the file name.

      Terms & ConditionsAccessibility statement

      Loading footer...