+7How to find the column that has an empty fields ?
as example. I have 50 attribute names some of them has values and other is empty .
i do not want to use 50 tester to check for each attribute if it has value or not ?
is there easy solution to get the required columns that has no value ?
FME 2021
thanks in advance
+54One way to do this is to use an Aggregator, merge all features to one collection, Accumulation Mode: Use Attributes From One Feature.
Then an AttributeExploder to create a feature for each attribute.
Then test where _attr_value has no value.
+35If all the attributes are exposed you can try and use an AttributeValidator where the rule is "Has a Value". You can select All Attributes in one click. The validator will also create a report for each failed feature so you can see what test is failed.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
