Hello, I would like to ask how to solve this problem,that there are several databases. In line, polygon, point and text formats. The question is whether it is possible to create an excel file that contains all database names, as well as what attributes are there as well as attribute names and alias names. In addition to this, what are the results in the attribute table and the corresponding domain names.
And export it to xls
Thanks in advance
Hi @dallas2011 this should be possible with a few steps and transformers in FME. To expose the name of the database from your source dataset, you will need to go into the Reader Feature Type > Format Attributes tab and click Exposed for fme_dataset. This attribute contains the name of the source database that the dataset originates from.
To create a list of all the attributes in the dataset, you can use the SchemaScanner transformer. This will scan your datset's schema and output a list feature from the <Schema> port that contains all the attribute names and their data type. To expose this list attribute, you can use the ListExploder. In the SchemaScanner, make sure to disclose any attributes you want to ignore using the Ignore Attributes Containing parameter. Your workspace at this point should look something like the screenshot below:
