How to remove a blank value from a List?

[#1]

Hello everyone,

I created a list of Months in my project, where it is displayed a blank check box, as you can see in the print screen below:

I looked into my data base an there is no blank fields, i mean, all fields are fulfilled in the table.

Someone know if it is possible to remove that blank check box from my List?

Regards,

[jonathandienst]

Somehow the blank field is being created in your load script and the problem (if it is a problem) should be fixed there. If the blank is not coming from your source, then it could be something like a conversion or a join that is not working properly.

You could suppress it in the list from the front end, but if I were you, I would make sure I understood where it was coming from before suppressing it. But the best is to fix the script.

[sunny_talwar · Accepted solution]

You can fix this in the script:

LOAD fieldNames,

          If(Len(Trim(Mes)) > 0, Mes) as Mes

FROM ....

[#4]

Thanks Sunny,

This if statement in the script fixed the blank filed issue.

Have a nice day!