Skip to main content
Newcomer
November 1, 2024

Data sources zero suppression with complex expression

  • November 1, 2024
  • 2 replies
  • 0 views

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6). 

ScottCharles_0-1730495141160.png

I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead.

ScottCharles_1-1730495277208.png

In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6.

ScottCharles_2-1730495605762.png

Is there a way to suppress zero after the script runs or write zero suppress into the script? 

Thanks Scott

2 replies

Expert
November 4, 2024
Newcomer
November 4, 2024

Thanks Marcus H