Forum Discussion

GregHertling's avatar
GregHertling
New Contributor III
2 years ago

matrix parser rule to change date to long

Hi, I have a matrix data source matrixed on Account.  Sample below.  One of the Account fields is a Date that I need to convert to a Long to store.  I can do the conversion but not sure how to target...
Parsing
  • GregHertling's avatar
    GregHertling
    2 years ago

    Hi, we actually have over 300 Account columns in the source file with various data types.  I was finally able to get this to work.  First I had to ignore any columns with no data.  Then before the return statement I had to add: api.ValueIsnumeric = True.  thanks for all of the help.

GregHertling's avatar
GregHertling
New Contributor III

hi Jack thanks for the reply.  I had tried args.value and args.line but those only return the header row (Args.Value=Account1; Args.Line=Code1, Entity, Account1, Account2, Account3)  I'm not quite sure how to use GetFieldValuesForSourceDataRow but I can't return anything meaningful with it so far.

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

Sorry, just to clarify, is this DS a Fixed, Delimited, or Connector? I'm just trying to understand where you're running code.

  • GregHertling's avatar
    GregHertling
    New Contributor III
    2 years ago

    I'm using a delimited file (.csv)

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      Ahh, ok, so your real problem is that you're parsing the header line, which you should instead bypass. Once you fix that, you can just use Args.Value in a rule or Complex Expression applied to the column you want to change, and it will give you the necessary value.

      The bypass will be automatic if the line doesn't contain something that looks like a number in the position you've mapped your Amount dimension to (which doesn't really matter anyway, since you have a matrix; but will still be used by the system to figure out if the line is valid). If that doesn't work, you can create an explicit Bypass rule, map it to a column (e.g. the Entity one), set it to "Contains at Position", "Entity", and it will work.

      • GregHertling's avatar
        GregHertling
        New Contributor III
        2 years ago

        unfortunately args.value is still only pulling the Account names and not the values.  I am putting the Rule on the Account1 column.  It seems it is only pulling the related Dimension values.  When I use args.line on the Amount, surprisingly I can at least see the string of values, however, I'm not sure how to isolate the conversion on just that Account.