[DataPort-import]merge 2 source columns into 1 dest. column

gison
gison Member Posts: 128
edited 2007-11-28 in NAV/Navision Classic Client
Our source is a .csv file which have some column need to be merged into one while we import into the destination tables.
for example: first name + last name => destinationName ,it's kind of this situation... does dataport possible to do it? :?

thanks for help.

Comments

  • Revolution1210
    Revolution1210 Member Posts: 161
    Yes, it is possible.

    Import you columns into variables, e.g., FirstName, LastName.
    Just define a variable as normal, then include this variable as a Dataport Field.

    You can then do any processing and update your table/field as required.
    Ian

    www.NextEqualZero.com
    A technical eye on Dynamics NAV
  • gison
    gison Member Posts: 128
    Revolution1210 wrote:
    Yes, it is possible.

    Import you columns into variables, e.g., FirstName, LastName.
    Just define a variable as normal, then include this variable as a Dataport Field.

    You can then do any processing and update your table/field as required.

    Hi Ian,

    I tried to do what you said, but in the Dataport field, I just can find the field which belong to the Dataitem table....I couldn't find the variables I defined.
    :?

    thanks for help.
  • Nagi
    Nagi Member Posts: 151
    Hello Gison,

    If you do a lookup in the dataport fields you'll just see fields from your table, this is correct, but you can type whatever you want and then define it as a global variable. In fact, you can do a lot of stuff directly in the dataport field if you want to, like function calls (which can be handy if you need to convert characters that aren't outputed correctly) and using '' to designate fixed text.
  • gison
    gison Member Posts: 128
    Hello Nagi,
    You just hit the nail on the head.
    thanks for help, and thanks Ian.

Categories