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
Concatination of columns
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
If you dont want delimiter then transformer stage is the best one. Try you will get it using stage variables.
Thanks, BK