Dataverse - add Run parameter to Pattern in Directory List

Follow

Jenny Jeppsson

• February 28, 2017 10:34

How do I use a Run Parameter as a pattern together with Wildcards "*" in the Directory name?

Defined Run Parameter = "Spec_Month" & String
Configured: Spec_Month = "201702"

In Node Directory List
Wanted Pattern: *201702*
Code? : "*"+{{^Spec_Month^}} +"*"

Similarly how do I add {{^CurrentDate^}} in an output file name
For example "Test_20170228.xlsx

 

0

• 

  Rocco Pigneri

  • March 01, 2017 19:30

  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
• 

  Nick Lancaster

  • March 28, 2018 05:06

  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.