Hi,
Have you tried change detector?
Pratap
Hi @john_eskilstuna, you can read schema features from a dataset with the Schema (Any Format) reader or the FeatureReader.
FeatureReader parameters
A schema feature has an attribute called "fme_feature_type_name" which stores name of the feature type (table), and a list attribute called "attribute{}" which stores attribute names and data types defined.
- fme_feature_type_name: feature type name
- attribute{}.name: attribute name
- attribute{}.fme_data_type: FME generic data type name
- attribute{}.native_data_type: data type name specific to the data format
See also here to learn about Schema Feature:
Dynamic Workflows: Destination Schema is Derived from a Schema FeatureRead schema features from the datasets that you want to compare schemas, explode the "attribute" list with the ListExploder. You can then compare the schema between the datasets.
Example:
Hi @john_eskilstuna, you can read schema features from a dataset with the Schema (Any Format) reader or the FeatureReader.
FeatureReader parameters
A schema feature has an attribute called "fme_feature_type_name" which stores name of the feature type (table), and a list attribute called "attribute{}" which stores attribute names and data types defined.
- fme_feature_type_name: feature type name
- attribute{}.name: attribute name
- attribute{}.fme_data_type: FME generic data type name
- attribute{}.native_data_type: data type name specific to the data format
See also here to learn about Schema Feature:
Dynamic Workflows: Destination Schema is Derived from a Schema FeatureRead schema features from the datasets that you want to compare schemas, explode the "attribute" list with the ListExploder. You can then compare the schema between the datasets.
Example:
Thank you once again @takashi !
