[resolved] Generating multiple rows with tJava

[Anonymous]

I've read similar threads to this, but nothing that quite answers my question. I'm trying to create a tJava that takes in a table and outputs a table for use by a tmap that will grab data from other tables. I need it to do this:

for (in_row : plan_row) {

    for (int i = in_row.StartYear;i <= in_row.EndYear;i++) {

        out_row.plan_id = in_row.id;
        out_row.year = i;
        makeThisARow(out_row);

    }
}
So input can look like this:
plan_id start_year end_year
1, 2016, 2018

And output like this:
1, 2016
1, 2017
1, 2018

I don't understand how to interact with the components connected to the tJava. How do I tell it 'give me each row' and 'create a row'?

[Anonymous · Accepted solution]

I think this might lead you in the right direction. You just need to change the code in the tJavaFlex to accommodate your requirements.

https://www.rilhia.com/quicktips/quick-tip-row-multiplication

[Anonymous]

rhall_2.0 wrote:
I think this might lead you in the right direction. You just need to change the code in the tJavaFlex to accommodate your requirements.

I found this link earlier and have been trying to solve the problem that was as well, but that gives me a different problem:

//start
for(short i = ((Short)globalMap.get("StartYear")).shortValue();i<((Short)globalMap.get("EndYear")).shortValue(); i++){  
//main
map_row.plan_id = ((Integer)globalMap.get("id")).intValue();
map_row.year = i;
//end
}

How do I get 'i' inside the main.

On a related note, is there some way to tell the IDE to show me the generated code?

[Anonymous]

That code should work. What error are you getting?

You will see a "code" tab in the bottom left hand corner of the design window. Click that to see the code.

[Anonymous]

rhall_2.0 wrote:
That code should work. What error are you getting?

You will see a "code" tab in the bottom left hand corner of the design window. Click that to see the code.

Arg, that should have been obvious.

java.lang.NullPointerException, globalMap("StartYear") is null for some reason.

[Anonymous]

OK, if you followed my tutorial I suspect that is being set in the tMap. Is that correct? Can you take a screenshot of your job and your tMap so that I can see what might be wrong?

[Anonymous]

I see what it is now...someone actually set a StartYear to null. I thought there was a constraint against that (there should be).
It works now. Thanks for your help!