Forum Discussion

KurtMayer's avatar
KurtMayer
Contributor
1 day ago

How can I force a delimited data source to not skip blank values in an Amount field?

I have a situation where I'm trying to load trial balances from QuickBooks. The source file I'm receiving has three comma-separated columns - Account+Description, Debit, Credit. QuickBooks has a qui...
Data Integration
Data Sources
Import
JJones's avatar
JJones
Icon for OneStream Employee rankOneStream Employee
6 hours ago
Can you give this a shot in a Parser Rule:
 
Dim defaultValue As Decimal = "0.00"
 
'Check the source value that was parsed
If args.Value.Length = 0 Then
'Nothing was found on this row, so return the default
Return defaultValue
Else
'This line has a value, so just return that value
Return args.Value
End If