Edit a .csv file

[Anonymous]

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.

[TRF · Accepted solution]

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/... 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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.