Talend community forum / [resolved] foreach variable in a context group?

Pim · 2009-09-21 18:56:33

Here's my problem that i'm hoping talend could help solve.

So i have a large db and I want to access data from that database using dynamic queries. Lets say I have a db with a column called "colors". I want the user to enter "blue" "red" "brown" and it will query (i.e. select * from somedb WHERE color = "blue" AND color = "red"...) the db and get the results from those three queries. I don't know what colors a user will put in, might be 2, might be 50. Is there a way to put those colors in as context group and do a foreach variable (colors) in a context group, generate a query and get the results from each of those queries. I would appreciate any help on this, thanks!

shong · 2009-09-22 05:11:24

Hello
You need query records dynamically based on each color entered by user.
Here is java example, please see my screenshots.
tJava_1 code:

Code:

String s=((String)globalMap.get("tMsgBox_1_RESULT"));
             
String [] array=s.split(",");
globalMap.put("array",array);

tMysqlInput_1 query:

Code:

"select * from person where color='"+(String)globalMap.get("color")+"'"

Feel free to ask for help if you have any trouble!

Best regards

shong

Uploaded Images

Pim · 2009-09-22 16:42:51

Thanks shong, i'll mess around and see what I can do, if I run into any issues i'll let you know, thanks again.

Pim · 2009-09-22 21:01:17

This was exactly what I was looking for, got it working perfect, thanks again!

peterpan · 2009-09-22 21:05:44

Hm.....

I think i can use it as well!!!

Thanks.

hiren · 2011-08-05 09:03:35

thnx

Announcement

Unanswered posts

#1 2009-09-21 18:56:33

[resolved] foreach variable in a context group?

#2 2009-09-22 05:11:24

Re: [resolved] foreach variable in a context group?

Code:

Code:

#3 2009-09-22 16:42:51

Re: [resolved] foreach variable in a context group?

#4 2009-09-22 21:01:17

Re: [resolved] foreach variable in a context group?

#5 2009-09-22 21:05:44

Re: [resolved] foreach variable in a context group?

#6 2011-08-05 09:03:35

Re: [resolved] foreach variable in a context group?

Board footer