How to concatenate 2 files with different FMT?

CloverDX Platform
1

Hi,

source1.fmt has “reference”, “name”, “address”

source2.fmt has “reference”, “name”, “address”, “country”

How do i concatenate them together to create the resulting fmt of “reference”, “name”, “address”, “country”?? CONCATENATE expects the 2 source FMT to be the same…

Thanks,
al

2

Hello,
in Conacatenate component all input ports have to have the same metadata so you have to “add” lacking field, eg. if you read data from database you don’t have to fill all fields (eg. “select $reference:=reference, $name:=name, $address:=address from customers”, but metadata have 4 fields), if you have a “transformation” component (Reformat, MergeJoin, Denormalize,…) before the Concatenate, you can change metadata there or you can put Reformat before Concatenate, which only changes metadata.