Missing values

KNIME Analytics Platform
#1

Dear All

Along with saying hello and wishing you a great weekend, I present the following problem
I have four fields called FEC_PAGO_DIVIDENDO, FEC_MIGRACION_HACIA_FLEXCUBE, MTO_INTERES_PENAL and MTO_INTERES_PENAL_PAGADO, which have missing values. What I need is for the nulls to be converted to 0 for the fields MTO_INTERES_PENAL and MTO_INTERES_PENAL_PAGADO.

I have occupied the missing values node trying to transform the null fields to 0, for the fields MTO_INTERES_PENAL and MTO_INTERES_PENAL_PAGADO that are of type number without success.

I don’t know what I’m doing wrong

Screen print is attached for understanding

image
image1394×778 114 KB

image
image1354×611 77.7 KB

image
image856×845 63.2 KB

#2

What is the result of the Missing Value node?

#3

The expected result for the fields MTO_INTERES_PENAL and MTO_INTERES_PENAL_PAGADO is that where it is null it is replaced by a zero

#4

I’d like to know what happened when you used the Missing Value node.

It would be easier if you uploaded the data and the workflow so that we could take a look.

#5

Link is attached

#6

@elsamuel I share the workflow with you on OneDrive according to instructions.

#7

I can’t access that file. It would be easier if you uploaded the workflow to the forum either directly or using a link from your KNIME Hub account.

#8

I try to upload it to the knime hub platform, without success as my workflow is over 11gb and the platform supports only 5mb.

I share file by onedrive to see if you can download it now.

#9

Hello @elsamuel, I shared the file with you again on onedrive, since the platform does not allow me to upload them due to the weight that exceeds one gigabyte

#10

@Pedro87, you don’t need to include all the data with the workflow. A subset would suffice, and would help you satisfy the upload size limit.

#11

Use the RULES ENGINE. I just used this to do something similar.

MISSING $column with the nulls$ => $column you want to replace data from$
TRUE=>$column with the nulls$

Set the node to replace $column with the nulls$

Or this is another option…

MISSING $column with the nulls$ => 0
TRUE=>$column with the nulls$

set the column to replace the $column with the nulls$

#12

Hello @elsamuel and @dphipps here I am attaching a workflow with some cases.

When occupying the missing value node, I only need it to transform the null values of the fields MTO_INTERES_PENAL and MTO_INTERES_PENAL_PAGADO into zeros.
KNIME_project.knwf (33.3 KB)

greetings and good week

#13

The workflow you uploaded seems to be functioning fine on my end.

This is the output from the CSV reader:
image

This is the output from the Missing Value node.
image

I didn’t make any changes to the workflow.

1 Like
#14

Thank you very much @elsamuel for the support.

#15

The RULES ENGINE does this. Replaces values in a field and also can create a new field.

#16

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.