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

gison

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.

Revolution1210

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.

gison

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

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

Hello Nagi,
You just hit the nail on the head.
thanks for help, and thanks Ian.