Skip to main content
Question

See if all attributes has value missing


stinah
Contributor
Forum|alt.badge.img+1

I am downloadning data by several url from different organisation webpages that I later import to tables in a Microsoft SQL server database.
I want to get the information if all the attributes that I exposed for a datasorce isn’t containing any values (the value is missing).
Is it a way too choose all or multiple attribute at the same time and test if they contain any values?
I have data that has like 50 attributes and it is going to take a long time to manually set like a test for each of this attribute individually.

5 replies

max_h
Contributor
Forum|alt.badge.img+10
  • Contributor
  • March 28, 2025

You can start by using NullAttributeCounter, it generates a table which tells you which attributes have null values (and even how many)


takashi
Supporter
  • April 5, 2025

Hi ​@stinah ,

Do you need to check if all the selected 50+ attributes are missing for each record, or in entire input table?


panda
Enthusiast
Forum|alt.badge.img+17
  • Enthusiast
  • April 5, 2025

you can use NullAttributeMapper > select all attributes or only the one you want > then you can use pythoncaller, to check if all those expose attributes are null dynamically.


danilo_fme
Evangelist
Forum|alt.badge.img+42
  • Evangelist
  • April 6, 2025
panda wrote:

you can use NullAttributeMapper > select all attributes or only the one you want > then you can use pythoncaller, to check if all those expose attributes are null dynamically.

Great


stinah
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • April 9, 2025

Perhaps I frased the question wrong. The goal is to get information if the attributes name has changed from the datasource when I download the data through a url. As I have the workspace set now I have a AttributeExposer that I import attribute name from an earlier downloaded file from the used url for the datasource and set that as the name for the attributes. But sometimes the organisation that is responsible for the datasource that I download change the attribute names - if that is the case all the attribute that i have in my written file is missing value (or null). So I wish to get the information when all the attribute that I written to a file has the value missing och null because the attribute name has changed and doesn’t exist anymore in the datsource.
So my question is can I get the information if multiple attribute that I have exposed but doesn’t really exists in the datasource anymore has value missing or null or even better is it a way to automatically always expose the correct attribute that the datasource has?
 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings