• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » routine which returns a list

#1 2008-07-03 17:21:14

docky
Guest

routine which returns a list

Tags: [date, List, routine]

I have created a routine which returns a list of Date for one Id.
I would like to put each element of this list in a table with the corresponding Id. The problem is that on a tMap the type of variable we can return  is only int, String etc...

Is there a way to extract each element of my list ??

thank you for help

#2 2008-07-04 09:57:48

jeremie
Member
Registered: 2008-02-11
Posts: 151

Re: routine which returns a list

Hi,

You have : ID and list of date like this ?

12; 12-12-2007,02-03-2008
15; 01-06-2007,02-10-2007,15-12-2007,25-03-2008

you can use tDenormalize to obtain

12; 12-12-2007
12; 02-03-2008
15; 01-06-2007
15; 02-10-2007
15; 15-12-2007
15; 25-03-2008

You see

Regards

Jeremie


Consultant BI Open Source
FRANCE

Offline

#3 2008-07-05 11:54:42

docky
Guest

Re: routine which returns a list

yep but you didn't understand what I wanted to say. With my routine I put the dates in a list in java (ArrayList).

But, I solve my problem by writing "insert into" directly in my routine instead of put dates in a list and after use a component to put in a table.

thx for your help

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » routine which returns a list

Board footer

Powered by FluxBB