We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Dataverse - add Run parameter to Pattern in Directory List

Comments

2 comments

  • Avatar
    Rocco Pigneri

    Dear Jenny,

    I believe you want the Directory List node to output all filenames that contain the Spec_Month in their name.  You can do so by putting the following in the Pattern property:

    *{{^Spec_Month^}}*

    When properties are written using the {{^ notation, the {{^ParameterName^}} is simply replaced with the parameter value when the node is run.  There is no need for plus signs, quotation marks, or any other punctuation.

    In this case, the value in the Pattern property will contain the following value when the node is run:

    *201702*

    As for adding the current date in the output file name, you could do that by typing the following in the File property:

    Test_{{^CurrentDate^}}.xlsx

    Just so you know, the {{^CurrentDate^}} parameter became available in 3.0.5 which was released a few days ago.

    Hope that helps,

    Rocco

    0
    Comment actions Permalink
  • Avatar
    Nick Lancaster

    Hi Rocco

    can the same parameter explained in

    https://lavastorm.zendesk.com/hc/en-us/community/posts/115000541805/comments/115000215825

    be used as input parameter in SQL statement?

    0
    Comment actions Permalink

Please sign in to leave a comment.