Forum Discussion

WillVitale's avatar
WillVitale
Contributor
11 months ago

Dynamic DataSource Load

Hello,

I was wondering if there's a way to dynamically load a flat file once per year for a specific month. We load data yearly for our CapEx Budget and was wondering if you can assign a static value such as |WFYear|M1? I tried it but failed so right now I just hard keyed it. 

Yes, I can put the time in the column the data I load comes in with no time period in the field because it's a YTD amount, but I just wanted to make it as dynamic and no chance for human error in it.

Thanks,

Will

Data Sources
Import
  • JackLacava's avatar
    JackLacava
    10 months ago

    Set it to a Complex expression:

    Return BRApi.Finance.Time.GetNameFromId(si, api.WorkflowUnitPk.TimeKey) & "M1"

    For performance reasons you might want to stash it into a global variable.

    There might be faster ways to get the year, you might want to experiment with what is available in the api object.

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    11 months ago

    Data Type = Current DataKey Time

    That will use whatever your workflow time period is.

    • WillVitale's avatar
      WillVitale
      Contributor
      11 months ago

      I tried that and it didn't work. We don't have any periods, it's just 1 full year workflow

       

      • JackLacava's avatar
        JackLacava
        Honored Contributor
        10 months ago

        Set it to a Complex expression:

        Return BRApi.Finance.Time.GetNameFromId(si, api.WorkflowUnitPk.TimeKey) & "M1"

        For performance reasons you might want to stash it into a global variable.

        There might be faster ways to get the year, you might want to experiment with what is available in the api object.