Clicky

  • Welcome to P2P Lending / NFT Lending Forum.
 

ETH.LOAN

News:

This was the original Lend Academy peer-to-peer lending forum, since forensically restored by deBanked and now reintroduced to eth.loan.

To restore access to your user account, email [email protected]. We apologize for errors you may experience during the recovery.

Main Menu
NEW LOANS:   | granbull.eth 0.299 Ξ | primeape.eth 1.500 Ξ | remoraid.eth 0.299 Ξ | ALL

Finding Null Values

Started by Peter, September 19, 2016, 11:00:00 PM

Previous topic - Next topic

Mouser

Having difficulty filtering on NULL values.  Inputting any numerical value in the "Months Since Last Delinquency" range fields excludes all returns without a value so trying to create a custom query.   

I know the language is not quite SQL but I cannot find the right syntax to make the query work.  I am attempting to filter only loans with a null value in the field mthsSinceLastDelinq. 

Tried several variations in the "Custom Filter - Experts Only" field including:
   mthsSinceLastDelinq isnull
   mthsSinceLastDelinq is null

PLS Version 7.904

Any suggestions appreciated.

Thanks, Mouser

sociallender

Close, but NAs are used for missing values.  Here is the code:

is.na(mthsSinceLastDelinq)

HTH, SL

TravelingPennies

Wonderful, that did it!
Appreciate the ongoing support.  Love the tool.

NEW LOANS:   | granbull.eth 0.299 Ξ | primeape.eth 1.500 Ξ | remoraid.eth 0.299 Ξ | ALL