Skip to main content
  • EN

How to extract fields that has values or records if single record also need to exclude the fields that has no value (empty or Null or missing) that is show in yellow color that need to be exlude in the selection




















































Filed1Filed2Filed3Filed4Filed5Filed6Filed7Filed8

5216603901NotABackRoad3 HighMedium

5387238226NotABackRoad4 MediumMedium

54 NotABackRoad Medium

5573780123NotABackRoad6 HighMedium

562878137NotABackRoad0 MediumMedium

Hi @amolparande I don't see any yellow color that would show the intended selection. Can you please attach a screenshot instead? thanks

 

Thank you DanAtSafe attached screen shot has yellow field it could be blank, null, empty I need to exclude from my selection final fields should those who has a least one record.

values.jpg @

Thanks @amolparande If you want to dynamically not write out fields where every record is blank, null, or empty, your workspace will have to scan every feature to test and then create a list of attribute schema from that. Please see https://knowledge.safe.com/articles/33838/dynamic-workflows-destination-schema-derived-from.html

Reply


Community Stats

30,108
Posts
114,294
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.