topic Re: Process String Array Data in Talend Studio

Process String Array Data

Sanjay5 — Sat, 16 Nov 2024 07:42:35 GMT

Hi,

I have a field with data type String Array and I am looking for some way to handle this in my Job.

I don't see data type as "String Array" in any of the components.

Is there a way to handle String Array in Talend?

Thanks,

Sanjay

Re: Process String Array Data

Jesperrekuh — Thu, 06 Sep 2018 10:56:02 GMT

No such component.

You can do it yourself, this is how I declare it in a tContext global variable which is an Object.

(new String[] {"something","something"})

If you want to make something flexible you probably end up using tJava, tJavaRow, tJavaFlex.

Re: Process String Array Data

Sanjay5 — Thu, 06 Sep 2018 20:04:00 GMT

Thanks Dijke,

I did not get how to process the String Array, Would you mind providing me few screen shots.

Regards,

Sanjay

Re: Process String Array Data

Jesperrekuh — Thu, 06 Sep 2018 20:50:51 GMT

An example... not how I exactly use it, just to give you an idea how to.

The purpose for what I used an array was to reduce parameters and store it all together in one variable, it was more an experiment not very practical and useful...

But I figured out how I could use arrays

Re: Process String Array Data

Sanjay5 — Thu, 06 Sep 2018 22:24:57 GMT

Thanks for your detailed explanation and useful trick to handle String Array, Unfortunately my requirement is little different.

I have a couchbase database which stores the data in the form of String Array and I am supposed to read it and process in Talend job.

After processing i am supposed to load the String Array back to Couchbase.

The issue is that i don't have any Data Type for String Array in Talend.

So not able to process String Array.

Re: Process String Array Data

Jesperrekuh — Thu, 06 Sep 2018 23:20:23 GMT

Some ideas ...
- your NameArray as an Object, which you cast to a String[]? That's what the example is... you could declare almost everything as an Object because its the super/parent of many non primitive datatypes ...
or
- tJavaFlex, do it in Java code... create/build the json yourself .
or
-look on talend exchange for tJSONDoc components... pretty advanced however I never used an array like this...

The output part is a whole different story... again try the JSONDoc components or tJavaFlex.

Re: Process String Array Data

Sanjay5 — Thu, 06 Sep 2018 23:55:57 GMT

Looks like treating String Array as Object would work for me.

Thanks for your Ideas