Forum Discussion

aprats's avatar
aprats
New Contributor II
3 years ago

Fields reference in a Connector Datasrc

Hi all, 

I need to assign a value in a field, dependeing on an other. I can do it in Delimited Files using  "api.Parser.DelimitedParsedValues()" but I don't know wich function can provide me the string of an other field.

So, in conclusion: how can I do this in a Connector Complex expression?

 

Thanks!

 

 

Data Sources
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    If you are using multiple fields then I would do it as 

    Dim fieldValues as String() = args.line.split(",")

    Then fieldValues(0) is first column and filed values(3) is 4th column. 

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    If you are using multiple fields then I would do it as 

    Dim fieldValues as String() = args.line.split(",")

    Then fieldValues(0) is first column and filed values(3) is 4th column. 

    • aprats's avatar
      aprats
      New Contributor II
      3 years ago

      Thank you so much for your help.

      I have a doubt: how the system know the field that I need?

      This are my list of fields:

      My args is INTERCO. I need to evaluate the OBJ field and depending on this, assign an INTERCO value.

      If I use args.line.split(",")(1) I'm referencing the fist field from my list?

      Thank you very much!