topic Re: Edit a .csv file in Talend Studio

Edit a .csv file

Anonymous — Sat, 16 Nov 2024 08:49:58 GMT

Hello, everyone.

Since I'm new in this Talend World.

I'm exploring the tool, but I was wondering how could I categorize the information of a .csv file, also, I would like to know how I can sumarize the quantities included in that file and if it's possible to organize the information in alphabetical order.

Best regards and thanks for your help.

Re: Edit a .csv file

TRF — Sat, 20 Jan 2018 07:01:34 GMT

Hi,
You have a lot of tutorials for these subjects:
- https://www.talendbyexample.com/my-first-talend-job.html as an example to work with csv file
- http://desireddata.blogspot.fr/2015/04/how-to-use-taggregaterow-component-in.html?m=1 for aggregation
- https://www.packtpub.com/mapt/book/big_data_and_business_intelligence/9781849514729/5/ch05lvl1sec38/sorting-data for sorting
- also this one for a combination of aggregating and sorting records https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/YYVSsDiyJ3vBHh9357Ds~Q

Hope this helps.

Re: Edit a .csv file

Anonymous — Mon, 22 Jan 2018 21:55:19 GMT

Thanks a lot for your help.
I was trying to use the tsortrow to order in alphabetical ascendent order the content (products column) on the csv file and multiplicate two columns with the aggregaterow, showing the results into an output csv file, but I couldn't.
The files you shared to me were helpful in some way

Re: Edit a .csv file

Anonymous — Mon, 22 Jan 2018 21:55:43 GMT

Re: Edit a .csv file

Anonymous — Tue, 23 Jan 2018 07:22:21 GMT

Hi,

What's the error message you are getting? Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Edit a .csv file

Anonymous — Tue, 23 Jan 2018 22:08:56 GMT

I'm using the tmap component to make a mathematical operation (multiplication) with the values of two different columns (price and quantity, string type as the SMUL requires) and then when I have checked all the values content in every single component I'm using and verify all of them to be string type, this message appears:I don't know if I'm doing or using the correct sentences or flow.

Do you have any idea of why this is happening?

Thanks a lot

Best regards

Re: Edit a .csv file

Anonymous — Tue, 23 Jan 2018 22:45:45 GMT

Look at the data types for the columns you are getting your data from. They are Strings. In fact, it looks like all of your columns are Strings. You need those columns set as Double. Go to your file component schema and alter the data type to Double. You will need to make sure that all of your column types are correct to carry out calculations like this.

Re: Edit a .csv file

Anonymous — Tue, 23 Jan 2018 23:03:15 GMT

Thank you!

I already set the columns as double, but when I check the .xls output file, it has no data, only the headers and the .csv original file has data, so I don't know what else I could do.

This one is the original file:

It is possible to order the data in alphabetical order?

I'm sorry if I'm making so many questions, I really appreciate your help.

Captura de pantalla (8).png

Re: Edit a .csv file

Anonymous — Tue, 23 Jan 2018 23:51:30 GMT

You will need to show us your input file component config, your tAggregateRow config and let us know how many rows pass through the job when it runs. I'll look again in the morning to see if this has been answered while I am away

Re: Edit a .csv file

Anonymous — Wed, 24 Jan 2018 16:26:43 GMT

I realized I had the property "Catch lookup inner join reject" (in the tmap) as false, then I set it as true and it worked.

Thanks a lot for your support.

Re: Edit a .csv file

Anonymous — Wed, 24 Jan 2018 17:29:53 GMT

I feel stupid for not spotting that from the screenshot last night. Good catch 🙂

Re: Edit a .csv file

Anonymous — Wed, 24 Jan 2018 17:33:52 GMT

Don't feel like that.

I do feel stupid because it was "Catch output reject", not the inner join haha.

Best regards