Skip to main content
A
aprats
Newcomer
August 29, 2022
Solved

Fields reference in a Connector Datasrc

  • August 29, 2022
  • 3 replies
  • 0 views

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?

 

aprats_0-1661766456401.png

Thanks!

 

 

    Best answer by ckattookaran

    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. 

    3 replies

    C
    ckattookaran
    Newcomer
    August 29, 2022

    Use args.line and use split operation.

    args.line.split(",")(1)

      A
      apratsAuthor
      Newcomer
      August 29, 2022

      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:

      aprats_0-1661791181181.png

      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!

       

       

       

      C
      ckattookaran
      Newcomer
      August 29, 2022

      That is a zero-indexed item, so in your case it is 3

      C
      ckattookaranAnswer
      Newcomer
      August 29, 2022

      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. 

        A
        apratsAuthor
        Newcomer
        August 30, 2022

        Thanks! It works absolutly fine.

        Terms & ConditionsAccessibility statement