topic Re: Vector data load in Talend Studio

Vector data load

mani1304 — Fri, 07 Jun 2019 11:22:29 GMT

Hi,

I have a file having 7 columns, then 7th column can be further splitted into several records on the basis of delimiter( ; ), In Ab Initio, I separate this 7th column in vector, but don't know how to do this in talend, can someone suggest on this.

e.g. the file has a record like a,b,c,d,r,f,g[100], like g[1] is like x,y,z,i,j,k and so on.. Number of 7th column records are not fixed.

Thanks in advance.

Re: Vector data load

nfz11 — Tue, 11 Jun 2019 05:05:40 GMT

Just use the split method native to Java strings:

String[] data = input_row.g.split(",");

You can use it in a tMap, a tJava* component or anywhere an expression is allowed.

Re: Vector data load

mani1304 — Tue, 11 Jun 2019 11:46:47 GMT

Thanks buddy, I did this in tjavaflex but how to do this in tMap, what would be the datatype for this, but I was looking something similar to vectors, but seems here this is missing.

Re: Vector data load

nfz11 — Tue, 11 Jun 2019 22:22:14 GMT

@mani1304 wrote:

Thanks buddy, I did this in tjavaflex but how to do this in tMap, what would be the datatype for this, but I was looking something similar to vectors, but seems here this is missing.

You can use the List data type. To build a list from the String array you could do this:

output_row.gList = java.util.Arrays.asList(input_row.g.split(","));

Re: Vector data load

mani1304 — Wed, 12 Jun 2019 05:15:40 GMT

Thanks, it works