Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!!!
Hi,
try to convert second file columns to string before tUnite and connect to tUnite as string.
Regards,
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.
You can try below approach
first flow insert record in excel file with string value, Second flow will append data .
Regards,
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?
Try these options
Regards,
Thank you a lot !!!
It works very well! You help me a lot.