Issue with concatenate node joining different data types

Hi,

I am running into an issue where I have to concatenate 3 different data files

I am having an issue with one of the columns as each file has a different datatypes.

From File-1 it’s a double, File-2 it’s a date and File-3 it’s an amount with double having amount values.

When I use concatenate the data type changes to “?” and the amounts are not handled correctly

How can i fix this issue, i need the amounts to be shown correctly