Ihave two tables in mysql and i want to write in one file excel.
the two tabes are :
Table TimeEntrie and table CustomValue.
- My problem is : I want to store in one file excell all the data that matches with the condition below:
1 - the timeentrie wich have the project_code == Custom_value.customized_id
And for these timeentries select All
2- that have custom_value.custom_field_id=13 or custom_value.custom_field_id=19
3- that have custom_value.custom_typeequals ("Project")
Can anyone can help me ?
You can add the necessary conditions in the expression editor in the output section of the tMap and can pass the values to output file. If you want the data to be written in same file, you can do it by selecting append option in tfileoutputexcel.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)
thanks to your reply Thwabi .
I have tried to like this but i have a null pointer exception :
In the table timeentrries i have 43164 data but the tmap entries receive only 54 data .
my scrennshots are :
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.