Dataverse - add Run parameter to Pattern in Directory List
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
-
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
-
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?
Please sign in to leave a comment.
Comments
2 comments