how to concatenate 2 files with different FMT?

achan

• June 24, 2008 00:00

• Answered

Follow

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

• 

  avackova

  • June 25, 2008 06:49

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.