ETL-Tools.Com

Deleting or avoiding Null values and Empty strings

More
3 years 7 months ago #22247 by Dj16122000
Deleting or avoiding Null values and Empty strings was created by Dj16122000
Could anyone explain to me how to delete or avoid null values and empty strings in a transformation?

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22248 by admin
Replied by admin on topic Deleting or avoiding Null values and Empty strings
Hello and welcome to the forum

This can be quickly done by using validator objects




May I also suggest watching the following tutorial
www.etl-tools.com/advanced-etl-processor...-quality-issues.html
Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22250 by Dj16122000
Replied by Dj16122000 on topic Deleting or avoiding Null values and Empty strings
I have tried to use this before but it isn't working for me. I get a lot of errors.
Could you help me?

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22251 by admin
Replied by admin on topic Deleting or avoiding Null values and Empty strings
You have told us what the errors are and have not provided any screenshots.

Are you expecting us to guess?

Please read the form rules and follow then
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22252 by Dj16122000
Replied by Dj16122000 on topic Deleting or avoiding Null values and Empty strings
Errors Like these
Attachments:

Please Log in or Create an account to join the conversation.

More
3 years 7 months ago #22253 by admin
Replied by admin on topic Deleting or avoiding Null values and Empty strings
Please make sure that the settings for "Is Null or Empty String" validation function matching the screenshot we provided to you yesterday
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Copyright © 2008-2026 ETL-tools.com. All Rights Reserved.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save