Read "|" delimited data from a java code.

chetan.c · Post by **chetan.c** » Mon Mar 12, 2012 1:47 am

Hi All,

I have a java transformer stage which is giving output as below.

col1|col2|col3...
data1|data2|data3|
.
.

I want to recieve this data and use this for a join.
Currently the java code is giving the output as a string.
Do I need to split data there into different columns or split string later with a different stage?
If i have to split data into columns what is the stage that I must be using?

Thanks,
Chetan.C

chetan.c · Post by **chetan.c** » Mon Mar 12, 2012 1:55 am

Currently trying out column inport stage.
But want know how recieve the data as seperate columns from the Code.

Thanks.

kandyshandy · Post by **kandyshandy** » Mon Mar 12, 2012 2:29 am

You can change your JAVA code to return multiple columns as output. I have seen this in at least 1 project.

chetan.c · Post by **chetan.c** » Mon Mar 12, 2012 2:56 am

So column export is not a good option?

Thanks,
Chetan.C

kandyshandy · Post by **kandyshandy** » Mon Mar 12, 2012 3:04 am

chetan.c wrote:But want know how recieve the data as seperate columns from the Code.

I answered your question but did not say that it is the best method. Anyways, column export can't be used for your case. It's column import to split one field into multiple. You can also use transfomer stage but you need to decide based on requirements & downstream transformations.

chetan.c · Post by **chetan.c** » Mon Mar 12, 2012 3:44 am

Yes right.
I am using column import itself, it was typo.

Now splitting into columns at code itself.

eostic · Post by **eostic** » Mon Mar 12, 2012 6:21 am

Definitely change the java class if you can...it can easily send it's output in multiple rows and individual columns.....

Ernie