ETL-Tools.Com

Deleting or avoiding Null values and Empty strings

More
8 months 2 weeks 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
8 months 2 weeks 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/tutorials/33-validator-tutorial.html
Mike
ETL Architect
Attachments:

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

More
8 months 2 weeks 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
8 months 2 weeks 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
8 months 2 weeks 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
8 months 2 weeks 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 © 2023 ETL-tools.com. All Rights Reserved.