formula, !isnull

[wonka1234]

Hi,

How do I create a formula (same column) to get the !notnull values.

!IsNull(([Mainframe_ACF2]))  I am trying this but getting values of 0 and -1.

Thanks

[CathyS_Slalom]

Hi @wonka1234, what is the end results that you are looking for? To filter out the nulls or flag the nulls?

[wonka1234]

@CathyS_Slalom  filter out the nulls. my result is currently:

[CathyS_Slalom]

@wonka1234 - for that purpose you can use filter tool. Select the column that you want to filter on and select the option "Is not null" to filter out the nulls from T anchor (stands for True)

[wonka1234]

@CathyS_Slalom  i do exactly that( filtered with multiple columns) , but i want to combine them all results into one column

need to get the results of this into one col

[CathyS_Slalom]

@wonka1234 I guess you want to create a filter with multiple conditions. In order to do that, you can click the custom and combine the conditions together. If you want the end results to meet all of the conditions then use AND, otherwise use OR.

[EN6924]

Use Union tool to append the results one below the other.

like below -

[Qizhan]

what does the" !IsNull" mean

[KrishnaChithrathil]

@wonka1234 

I'd suggest you to use Union Tool. either before the Filter or after Filter.

If the column names are all same, Give auto config by name. If all column names are not same, you can make it similar using a select tool as well.

Thanks,

Krishna

[KrishnaChithrathil]

@Qizhan 

that's a check. If a value is null or not. 

If we use filter with !IsNull([Field1]), the true condition would be all the not null values in Field1 column. 😊

Thanks,

krishna