MetaData Merge

cloverdm

• April 22, 2016 00:00

• Answered

Follow

Hello Support

we have two metadata like follow in Sandbox ,

+meta
-COUNTRY_DATA.fmt
-COUNTRY_INDEX.fmt

now i have to create a metadata(i.e COUNTRY_COMBINED.fmt) which is a combination of both ,but incase any of the parent meta data is modified then the child meta data should automaticaly resolve the changes , Will it be possible in CLover , I am not looking for a solution that already availble in Designer , right click on meta of Graph from Outline -> Newmetadata -> Merge existing

Thanks ,
DM

• 

  Pedro Vazquez Rosario

  • April 22, 2016 17:53

  0

  Comment actions Permalink

  Hi,
  
  There is no direct way to accomplish this, but you can definitely use Jobflows and create merged metadata using XMLWriter. The following is the steps to accomplish this:
  
  

  • Use XMLExtract to extract the name and type from your metadata fmt files.
  
  
  • Use SimpleGather to join both fmt files together.
  
  
  • Use ExtSort and Dedub to remove any duplicate values.
  
  
  • Use XMLWriter to create a new fmt file with the combine data.
    [list:48cn54le][*:48cn54le]Root Element should be called Record with attributes (e.g. fieldDelimiter, recordDelimiter,name)
  
  
  • Have a Child Element called Field with attributes name and type (this is where you will map your edges)

  [/*:m:48cn54le]
  

  Run a Jobflow with ExecuteGraph, if you add any new field to the parent metadata.

  [/list:u:48cn54le]
  
  I have also taken the liberty of adding an example server project with this process.

  • MergeMetadata.zip

Please sign in to leave a comment.