How to append the column

[sachidanand]

Hi,

I have one ODBC stage Transformer and Sequential file

there is a column (PRODID) in ODBC and i want to keep
a character 'x' appended for every row
how should i add character in starting of that record

it should look like this
ODBC = 12345
Transformer= x+12345
Sequential file = x12345

[I_Server_Whale]

In the derivation of the column PRODID, concatenate 'x' to the value.

Code: Select all

x:InLink.PRODID

Whale.

[sachidanand]

In the derivation of the column PRODID, concatenate 'x' to the value.

Code: Select all

x:InLink.PRODID

Whale.

THANKS

W H A L E ..................

[sathish2cool]

Hi...

if its going to be table,you can very well write an user defined query like this...

select 'x'||PRODID from tablename;

Hope it helps......

cheers,
Sathish

[I_Server_Whale]

Welcome Aboard !

[wnogalski]

IMHO Whale's solution is much more readlable and easy to maintain - if You have a complex query then it's hard to see the concatenation and You end up wondering: "Why the hell do I have these strings here?".
If You do it in Transformer You can give it a name "AppendX" and at a glance You know that something happens there - double-click and You know all the details.

[DSguru2B]

Annotations my friends.

[mchivuku]

Gurus,

This solution of x:col is gonna return a NULL value if the value of col is NULL.

i have 3 cols to be concatenated say x,y,z.
If isNull(x) then ' ' else x : If isNull(y) then ' ' else y : if isNull(z) then ' ' else z

this condition does not return the value of z ,if the y becomes a NULL value.

How do you solve this?

Thanks,
Murali

[kumar_s]

You can use NullToZero() or NullToEmpty() available under DS Transform and can concatinate directly.