how to validate "Null" value from a column in a line of record
edited Dec 23, 2019 11:00AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered
Hi Experts,
i am trying to validate a line of record with 8 delimited values.
if i have a null value in 5th delimited value, how can i evaluate and get the output.
below is an emaple.
line of record:
entity, market, product, company, description, quantity, custom1, amount
1234, 111193, 212223, company1, FDMEE-Load-description, ,material,200
from the above line of record, I have "quantity" is NULL. how can i check it. it is a number vlaue.
i used below item, but it is not working
quantity = sLine.split(",")[6]
(quantity!= 0) == True
1