DSXchange

Hi there,

How to concatinate different columns in transformer stage.
The datatypes of the columns varies from varchar ,timestamp,bigint.
How to concatinate 70 odd colums which have the above mentioned datatypes. Let me know the operator for this concatination. Also please provide me with a example. Is this scenario possible with any other stage like Modify or column generator.

Thank you
Sai

Posting the same question twice won't get any better answers.
The only possible stage is Transformer.
Modify does not permit multiple argument functions (such as concatenate) while generators do not use input columns at all.

You can try with column import/export. Example if you have A,B,C as 3 different columns. Through column import/export we can make it as A,B,C as a single individual column. But delimiter will be there or will exist. Probably you can try to get more from that.
If you dont want delimiter then transformer stage is the best one. Try you will get it using stage variables.