Hello ,
is there a way to find the layers name that has only attribute names but all attributes name has completely no data inside it
source data :oracle non spatial
FME 2021
Thanks in advance
Solved
Which method to find the layers name that has completely no data inside?
+7- Contributor
Best answer by david_r
My preferred method would be as follows:
- Use a FeatureReader in "Schema Only"-mode to get a list of all the table names.
- Use a SQLExecutor to retrieve the number of records for each table, e.g.
select count(1) as MY_TABLE_COUNT
from @Value(fme_feature_type_name)- Use a Tester to check if MY_TABLE_COUNT= 0
This will avoid reading any data into FME, which is very efficient especially if there are tables with a lot of data among the empty ones.
- Best Answer
My preferred method would be as follows:
- Use a FeatureReader in "Schema Only"-mode to get a list of all the table names.
- Use a SQLExecutor to retrieve the number of records for each table, e.g.
select count(1) as MY_TABLE_COUNT
from @Value(fme_feature_type_name)- Use a Tester to check if MY_TABLE_COUNT= 0
This will avoid reading any data into FME, which is very efficient especially if there are tables with a lot of data among the empty ones.
You'll find it on the schema feature, it's not necessary to expose it manually (note that the name is lower case):
Make sure to configure the FeatureReader to only read the schema features, and not to include the table contents:
+7- Contributor
david_r wrote:
You'll find it on the schema feature, it's not necessary to expose it manually (note that the name is lower case):
Make sure to configure the FeatureReader to only read the schema features, and not to include the table contents:
Thanks a lot
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.