06-15-2020 08:29 AM
12/3/2018
Data Source Parser Question: Client's data file contains 12 columns for the months no matter when it is run for the year. If it's January, it will have 12 columns showing Jan - Dec. Does anyone have a Parse Rule or another method of getting just the current month to import.
06-26-2020 08:47 AM
I managed to optimize the code:
Dim povPeriod As String = TimeDimHelper.GetNameFromId(api.WorkflowUnitPk.TimeKey)
Dim colNo As Integer = povPeriod.Split(""M"")(1).XFConvertToInt + 3
Return api.Parser.DelimitedParsedValues(colNo)