Expression in List Box

[Anonymous]

I have the below expression but I am not seeing the correct results.

I have a column FIRST_ASSGN_DT. When this column is Null = UnAssigned. When this column is not null = Assigned.

=If(WildMatch(FIRST_ASSGN_DT, '*'),'Assigned')AND If(ISNULL(FIRST_ASSGN_DT),'UnAssigned')

[trdandamudi]

Please give a try on the below:

=If(Len(Trim(FIRST_ASSGN_DT')) > 0,'Assigned','UnAssigned')

[sunny_talwar]

May be like this:

If(Len(Trim(FIRST_ASSGN_DT)) > 0, 'Assigned', 'UnAssigned')

[Anonymous]

My Unassigned is not showing results in the list box. There are unassigned rows with empty values. So maybe it's blank instead of null? Not sure.

[trdandamudi]

Can you please post a small sample...

[sunny_talwar]

I am not 100% sure what you mean. What are you expecting to see?

[Anonymous]

See attached. I cannot filter on UnAssigned as it's filtered out but in my straight table there are blank/null values.

[sunny_talwar · Accepted solution]

Try adding this to the script:

NULLASVALUE First_Assign_Date;

SET NullValue = ' ';

LOAD id,

    First_Assign_Date

FROM

listbox.xlsx

(ooxml, embedded labels, table is test);

and reload and see if it works now