get together file Excel in a single file with two types in a same column

Seven Stars

get together file Excel in a single file with two types in a same column

Hello

 

I have two input Excel files  : one file in String, and an other in Double.

I want gather together these files in a single Excel file. But the matter is : the output file is in a type.

 

The first file is : 

Column A(String)    Column B(String)   Column C(String)          Column D(String)

Month                           January                    February                     March

 

The second file : 

Column A (String)   Column B(Double)   Column C(Double)          Column D (Double)

ListA                        1573,12                      1335,24                               1114,58

ListB                           954,12                      2124,14                                1254,36

 

 

 I want have this output file : 

Column A(String)    Column B(String +Double)   Column C(String+Double)          Column D(String+Double)

Month                      January                                      February                                  March 

ListA                        1573,12                                        1335,24                                    1114,58

ListB                           954,12                                        2124,14                                  1254,36

 

I tried to use the component tUnite or tMap but I can't have two types in a single file (String and Double). 

 

This is error log of tUnite.

Error in the component's properties:Type mismatch: cannot convert from String to Double

Type mismatch: cannot convert from String to Double

Type mismatch: cannot convert from String to Double

Type mismatch: cannot convert from String to Double

Type mismatch: cannot convert from String to Double

Type mismatch: cannot convert from String to Double

 

Thanks in advance !!!!!


Accepted Solutions
Nine Stars

Re: get together file Excel in a single file with two types in a same column

ExcelTgt1.PNG

Try these options

 

Regards,

Veeru Boppudi

All Replies
Nine Stars

Re: get together file Excel in a single file with two types in a same column

Hi,

 

try to convert second file columns to string before tUnite and connect to tUnite as string.

 

Regards,

 

Veeru Boppudi
Seven Stars

Re: get together file Excel in a single file with two types in a same column

The matter is : Excel read that as a text if i put all in string.

I need the values to make a graph, so in double....

 

It's a big matter.

Nine Stars

Re: get together file Excel in a single file with two types in a same column

You can try below approach

 

ExcelTgt.PNG

 

first flow insert record in excel file with string value, Second flow will append data .

 

Regards,

Veeru Boppudi
Seven Stars

Re: get together file Excel in a single file with two types in a same column

I think that I am almost there. I have done it but i always had a file without months.

 

How append data for the second flow? There is a option to check?

Nine Stars

Re: get together file Excel in a single file with two types in a same column

ExcelTgt1.PNG

Try these options

 

Regards,

Veeru Boppudi
Seven Stars

Re: get together file Excel in a single file with two types in a same column

Thank you a lot !!!

It works very well! You help me a lot.

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.