Avoiding '-' Values

[NavinReddy]

Hello Experts,

i have table like this im trying to avoid blanks with different expressions which im not able to achive can some one help me

how can i avoid blanks in scrip side

• Where Match([Controls LOB] ,'Mortgage Banking','Transaction ','Card ','Auto','Student' Commerce Solutions',' IT');
• Where Not Match( [Controls LOB] ,'-' or [Controls Load_Date],'-');
• Where len(Trim([Controls LOB])>0);

i used in my script these expressions but still im getting blanks in chart

can some one help me

Thanks In Advance

Niranjan

[sunny_talwar]

Try this one again with correct placement of parenthesis:

TableName:

LOAD yourFieldNames,

          [Controls LOB]

FROM SourceFile

Where Len(Trim([Controls LOB])) > 0;

[sunny_talwar · Accepted solution]

Also I hope you are not creating a table box object with fields from different tables in your database. Cause if you are then you might still see blank [Controls LOB] because they don't have a value for them from another table you have in your table box object.

[NavinReddy]

Yes still im getting blanks because another mapping table don't have data is that reason

[sunny_talwar]

I don't think mapping table in itself could be an issue. But where ever you are mapping it to (using applymap) may have empty rows causing the issue. Can't really say anything without seeing it.

[NavinReddy]

thanks i think your above answer is might correct