topic Re: Loop into a table in Talend Studio

Loop into a table

DrGenious — Tue, 10 Mar 2020 09:13:33 GMT

Hello ,

I have a table in hive and I want through java to make a for statement with table's length. How can I do that?

Thanks a lot.

Re: Loop into a table

Anonymous — Sun, 15 Mar 2020 10:16:07 GMT

@DrGenious, can you take an example to explain your requirement?

Regards

Shong

Re: Loop into a table

DrGenious — Tue, 17 Mar 2020 07:48:00 GMT

@shong

for (int j = 0; j <names.length; j++) {
ls_table = names[j][0];

if ((input_row.Equipment_Id != null) && (ls_table != null) && (input_row.Equipment_Id_.startsWith(ls_table))) {
ls_info = "the name is " + names[j][1];
}

I have the file with this names table, but I dont know: 1) How to upload it into talend.

2) How to loop with the table's name.

Re: Loop into a table

Anonymous — Wed, 18 Mar 2020 03:54:35 GMT

Sorry, I can't still understand your question well. However, if you want read data from file, you can use the tFileInputxxx component such as tFileInputDelimited(for .txt or .csv file), tFileInputExcel (for excel file).
To loop the table name read from file, you can use tFowToIterate component, something like:
tFileInputDelimited--main--tFlowToIterate--iterate....
Take a look at the component documentation and learn this component.

Regards
Shong

Re: Loop into a table

DrGenious — Wed, 18 Mar 2020 06:49:52 GMT

@shong

for (int j = 0; j <names.length; j++) {
ls_table = names[j][0];

if ((input_row.Equipment_Id != null) && (ls_table != null) && (input_row.Equipment_Id_.startsWith(ls_table))) {
ls_info = "the name is " + names[j][1];
}

As you can see in the above code, there is a loop which loops until names.length ( names is the table). Then ls_table has the value of the names[j][0]. My question is how I insert this table into talend and then how can I loop with this table's length like the code above. I know about tfileinputdelimited and tflowiterate but I want to write it in java.