topic Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio in Talend Studio

[resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

zLucy — Fri, 15 Nov 2024 21:25:46 GMT

Hi,

I would like to iterate a hashMap or an arrayList in talent open studio, and, for each iteration, I would like to write a new csv row! I've done many tests but the result I get is the override of the first line. Below i post an example.

The tSetGlobalVar_1component creates the arrayList.

The tJvava_1 component inserts values to arrayList.

The tLoop_1 component loop to arrayList from 1 to arrayList.size

The tJavaFlex_1 component get the ArrayList from globalMap and iterare throw it and for each iteration, write the the row to cor column in row1

The tFileOutputDelimeted_1 has one column "code".

The output csv file, in the end, has only one row with last value of arrayList.

Could someone help me?

Thanks!!!

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

Anonymous — Mon, 04 Sep 2023 09:42:38 GMT

You need to set a dynamic output file name on tFileOutputDelimited, eg:

"D:/file/"+(String)myList.get(((Integer)globalMap.get("tLoop_1_current_iteration"))-1)+"out.csv"

otherwise, the component always create a new file with the same name for each iteration.

Hope it helps you.

Regards

Shong

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

zLucy — Mon, 04 Sep 2023 12:57:37 GMT

Hi @Shicong Hong and thanks for yours reply, i don't want to generate more files, i would to generate one csv file with more rows at the same column.

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

Anonymous — Tue, 05 Sep 2023 06:35:39 GMT

Check the 'Append' box on tFileOutputDelimited to append rows to an existing file.

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

zLucy — Tue, 05 Sep 2023 09:17:52 GMT

I have checked the 'Append' box but nothing has changed

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

Anonymous — Tue, 05 Sep 2023 10:50:46 GMT

For testing, add a tLogRow before tFileOutputDelimited to print the value on the console to see if it has the expected output data.

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

zLucy — Wed, 06 Sep 2023 07:52:26 GMT

Hi @Shicong Hong , i checked the "append box" in base settings of tFileOutputDelimted_1 and now it works!

I selected the wrong checkbox (row_mode in advanced settings), the Italian translation fooled me! A thousand thanks.

Re: [resolved] How to Iterate throw on an hashmap or arrayList and write the result in a csv file in talend open studio

Anonymous — Thu, 07 Sep 2023 02:45:25 GMT

Glad to hear that, thanks for your feedback!