You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "usbrandon (via GitHub)" <gi...@apache.org> on 2023/12/21 18:05:28 UTC

[I] [Feature Request]: Text input transform : Offer option to define what TEXT should represent null values. (hop)

usbrandon opened a new issue, #3509:
URL: https://github.com/apache/hop/issues/3509

   ### What would you like to happen?
   
   Many file import and export utilities allow people to define characteristics of their files, like delimiters and how NULL should be represented.  What I propose is adding this feature to the Text Input transform so if someone exported a file where in certain fields a word of their choosing is the only token present, that would be interpreted as a NULL.
   
   Today, the workaround requires taking the field as a String, since the values for "NULL" string text could conflict with say, a Date Time or Integer, etc.   Then one has to use "Null if" on the String columns, then a Select to straighten out metadata.   That is a lot of overhead that could have been prevented by simply allowing someone to specify a token for null right at import.
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Text input transform : Offer option to define what TEXT should represent null values. (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #3509: [Feature Request]: Text input transform : Offer option to define what TEXT should represent null values.
URL: https://github.com/apache/hop/issues/3509


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Text input transform : Offer option to define what TEXT should represent null values. (hop)

Posted by "usbrandon (via GitHub)" <gi...@apache.org>.
usbrandon commented on issue #3509:
URL: https://github.com/apache/hop/issues/3509#issuecomment-1867665431

   Wow.... 10 years and I never knew that...  now I know...
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature Request]: Text input transform : Offer option to define what TEXT should represent null values. (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #3509:
URL: https://github.com/apache/hop/issues/3509#issuecomment-1867326853

   Hi Brandon,
   
   This is what the "Null if" column does in the fields section of the text file input.
   I just tested it on a simple string field and it works as expected.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org