I want to remove rows with empty cell in plant column
would someone please help me with this
Hi @Mai_Nashaat , for this you can just use the Row Filter node.
If they are actually âmissingâ values, you can exclude âmissingâ items as shown here:
If they are some other value, then you can exclude using pattern matching. hope that helps
Hi @takbb & @Mai_Nashaat
I have the impression the empty cells are not âMissing Valuesâ but â0-lengthâ strings ? Is this the case ?
Happy New Year !
Best
Ael
@aworker Yes you are right I think. It might be zero-length strings (although I couldnât put in a zero length string on a table creator without it becoming âmissingâ), but it could also be one or more spaces or other whitespace characters.
I was trying to decide if the image was of the Table Creator config window, or the output port. And yes, I now see it has âRow IDâ as a column heading, which means it is the output port⌠in which case it would have shown â?â for missing values.
@Mai_Nashaat
If the cell contains space characters or âwhite spaceâ , e.g. space/tab and so on then the following Row Filter could work, using the regex pattern
[\s]*
If you still canât get it to work, then if possible, can you upload a workflow containing your sample data and somebody will be able to help further.
yes they are not missing values but what is 0-length?
they should be numbers as they are the totals of the quantities inprevious plants
Hi @Mai_Nashaat, as some of them begin with a B, they donât appear to be purely totals, but that probably doesnât matter for our purposes here.
A âzero length stringâ is a string (textual) value containing no characters (not even a space character).
I would give the above regex a try and see if that works for you. If not please upload a sample of your data, or a demo workflow.
@Mai_Nashaat - Another easier option could be âColumn Auto Type Cast Nodeâ.
Select the missing value patter as âemptyâ, it will convert all the 0-length based string to missing values then go for a Missing Value node and remove those.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.