2

I am having some difficulties on how to dynamically create a metadata, which need to be extracted from the header line of a flat .csv file in CC.

Usually, I manually define the metadata by select New Metadata --> Extract from flat file in CC. However the metadata of the file may changes with additional columns. Thus, I do not know the metadata of the file and I can not define it in this static approach.

It would be helpful if you could suggest a solution to create metadata dynamically and using this newly created metadata for connecting to other components. Perhaps an example graph file for demonstration would be great.

Thanks, Andy

user3278194
  • 45
  • 3

1 Answers1

1

I have discovered this kind of solution.

You just have to fill in flat .csv filename into csv readers and writers.

  1. MetaDataMaster.grf - runs the graphs below.
  2. MetaDataCreator.grf - creates metadata according to csv header and write it into meta_example.fmt file
  3. MetaDataUser.grf - Reads csv according to created meta_example.fmt file - you can add there a reformat and use just some predefined fields.

You can run the 2nd and 3rd graph separately to test it.

Josef Pithart
  • 276
  • 1
  • 4