tmap display

Four Stars

tmap display

TableTimeEntries.PNGtable custom_values.PNG

 

hello , 

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

and 

3- that have custom_value.custom_typeequals ("Project") 

 

Can anyone can help me ? 

thanks

custom 

 

 

 

My probCapture.PNGtmap.PNG

Highlighted
Employee

Re: tmap display

Hi,

 

    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.

 

Warm Regards,
Nikhil Thampi

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 :-)


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)
Four Stars

Re: tmap display

I have tried to do this but the output result is diffrent of the espected
result.
Four Stars

Re: tmap display

I have tried to configure tmap but the result is different of the espected result.

Please can you give me an example of thsi configuration . 

 

Seven Stars

Re: tmap display

 

Hello toumakabibiche,

 

here is an example of how I would try to resolve your question:

 

tmap_display.jpgtMap configuration

 

 

Best regards,

 

Thomas

 

 

 

 

 

 

Four Stars

Re: tmap display

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 : 

Four Stars

Re: tmap display

Captureend.PNGCapturenullpointer.PNGCapturetmap.PNGCapturetmapinterne.PNGCapturetmap.PNGExpression.PNG

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.