Forum Discussion

fc's avatar
fc
Contributor
27 days ago

Use 2 fields to determine dimension value in datasource

Hi all, I need to set up a complex expression to assign a specific value to the U6 dimension based on 2 source fields. Below part of the list of those source fields. The code I set up for the c...
Data Sources
BenEppel's avatar
BenEppel
New Contributor III
27 days ago

Since this is a connector data source, I don't think api.Parser.DelimitedParsedValues() will work. I've used logic like this for complex expressions in connector sources. Below is index based, so field 1 will be 0, field 2 will be 1, ect..

 

Dim fieldValues As String() = args.Line.Split(","c)

    Dim Field1 As String = fieldValues(0).Trim()
    Dim Field2 As String = fieldValues(1).Trim()
    Dim Field3 As String = fieldValues(2).Trim()
    Dim Field4 As String = fieldValues(3).Trim()

I would recommend using a composite transformation rule if you can. There are examples in the design and reference guide.