Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only
  • 1.  Dataverse - add Run parameter to Pattern in Directory List

    Posted 02-28-2017 03: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

     



  • 2.  RE: Dataverse - add Run parameter to Pattern in Directory List

    Posted 03-01-2017 12: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



  • 3.  RE: Dataverse - add Run parameter to Pattern in Directory List

    Employee
    Posted 03-27-2018 22: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?