matrix parser rule to change date to long

Question

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 the value to convert when in a matrixed data source.
If it were a delimited data source I would use: Dim sDateField As String = api.Parser.DelimitedParsedValues(6).  Is there a way to identify the value in a matrixed data source?
thanks
Greg

Code1
Entity
Account1
Account2
Account3

Test1
Entity1
1/1/24
0.025
0.5

Test2
Entity2
5/1/24
0.025
0.5

Test3
Entity3
3/1/25
0.025
0.5

GregHertling · Accepted Answer

In your source filehow many Account columns? Did you create the same amount of Dim in your DataSource? Did you set up the Matrix Header Values Line# to 1 for each dimension/headers?Then did you do your transformation for all the account Headers?

Can you send us a picture of the right side of the Data Source? And an Account Dim print screen as an example?

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.

JackLacava · Answer

You should be able to get your source value with args.Value, or the whole line with args.Line, or try to get the line in a dictionary with api.Parser.GetFieldValuesForSourceDataRow(si, api.RowGUID).

Code1	Entity	Account1	Account2	Account3
Test1	Entity1	1/1/24	0.025	0.5
Test2	Entity2	5/1/24	0.025	0.5
Test3	Entity3	3/1/25	0.025	0.5

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded