How to Marge one column values into other column vales within same table

[bhaskar_sm]

Hi all,

I have a excel sheet that contain “code” and “prevcode” column I want to Marge “prevcode” column values into the “code” column.

please find the attached snap shoot of excel sheet for clear understanding.

Thanks

[swuehl · Accepted solution]

It's not clear to me what you want to achieve.

I assume you want to duplicate the lines, one time with Code, one time with PrecCodes AS Code:

Table:

LOAD

     Prod,

     Type,

     Code,

     /// all other columns EXCEPT PrevCodes

...

FROM ....;

CONCATENATE (Table)

LOAD

     Prod,

     Type,

     PurgeChar(SubField(PrevCodes,'#'),'#') as Code,

     // all other columns EXCEPT Code

...

FROM ...

WHERE len(trim(PrevCodes));

[bhaskar_sm]

Thanks, swuehl

[sunny_talwar]

If you got the response you were looking for, please close the thread by marking swuehl's response as correct answer

Best,

Sunny

[#5]

load

type,

code

path of the excel;

concatenate

load

name,

precode as code

path of excel

then automatically it will combine as 1