Good morning all,
I am having an issue with an SC solution I built. I am taking an excel file, and using the values there to push to a UDTable. Since Excel is being used to push the data, there will be times where the values will be null. With strings this isn't a problem, but with dates and numbers it is. I know if I can just see one example of doing this, i'll be fine, but alas, that's impossible to find on the net. I wish I could code it.
If I were coding this for the number value, I'd say:
IF ExcelFileField = null THEN 0 ----> UDTable.Number01
ELSE
ExcelFileField --> UDTable.Number01
For a Date Value I'd say:
IF ExcelFileField = null THEN 99/99/9999 ----> UDTable.Date01
ELSE
ExcelFileField ---> UDTable.Date01
I've been using different functoids in my conversion but so far I haven't been able to get anything to work. I've been able to check the value using the conditional functoid, but it throws a TRUE/FALSE value to UDTable.Number01 resulting in an error. I need it to throw a 0 instead. I appreciate your time and help everyone.