topic Re: How to use array in a context in Talend Studio

How to use array in a context

Anonymous — Mon, 18 Jun 2018 23:15:54 GMT

Hello,

I would like to use an array in a context but how i can create this ?

- In a string like "Nike", "Adidas", "Rip Curl" ?

Finaly, it's to test if my current value is in my array but all i test not work

Do you have an idea ?

Thanks

Re: How to use array in a context

Jesperrekuh — Wed, 20 Jun 2018 00:32:10 GMT

(new String[] {"adidas","morty","jump", "up","down","picklerick"})

Re: How to use array in a context

Anonymous — Wed, 20 Jun 2018 07:06:50 GMT

I think list of values in context type can be used for that purpose

Re: How to use array in a context

Jesperrekuh — Tue, 17 Jul 2018 00:20:19 GMT

Single dimension:

(new String[] {"adidas","morty","jump", "up","down","picklerick"})

Multi:

( new String[] { new String[] { "jabadabadoo", "wilmaaaaa" } , new String[] { "rick", "sanchez" } , "morty","jump", "up","down","picklerick"} )

Please elaborate on what you're planning to do... and why multi dimension?

Re: How to use array in a context

Anonymous — Tue, 17 Jul 2018 04:02:51 GMT

Hi arnaudbroens
Define the variable with string type, and use tNormalize to normalize the value to multiple rows, do an inner join between input data and the predefined values. eg:
tMysqlInput--main--tMap--->tLogrow
|
lookup--tFixedFlowInput--tNormalize
on tFixedFlowInput: output the value of context variable

Regards
Shong