Len()

[Vamsi0529]

Hi Team,

I need a small help from you guys.

I am writing a where expression in data load editor.

I have Queue column which having null value 

For example it's looks like this  for removing that I am writing expression in DLE like below.

Ex: 

Participants:

Load *

Where len("Queue Name") >0;

Load

CongratulationId,

queueName as [Queue Name],

User ID

From **** (qvd);

If I do it in DLE it works fine I want to write it in table measure in frontend visualisation.

How to write that expression in set analysis in the table measure column.

I have written like this. Like : count({<direction={inbound},[Queue Name] = {"len()>0"}>}distinct ConversationId)

I am not sure what I have written is right or wrong can anyone please help me with right set expression.

Thanks for your help guys 

[Nicolae_Alecu]

Hello @Vamsi0529 ,

You can use this : 

Count({<Direction={'inbound'},[Queue Name]={"*"}-{''}>}distinct ConversationId)

 Best Regards,

[BrunPierre]

If you're confident that the values are Null, you can use the following expression:

=Count(Distinct {$<Direction={'inbound'},[Queue Name]={"*")>} ConversationId)

if you suspect the values might be blank or contain only spaces, you can use this expression:

=Count(Distinct {$<Direction={'inbound'},[Queue Name]={"=Len(trim(Field))>0")>} ConversationId)

[Vamsi0529]

Sure, Thanks for the solution. I will check and let you know the feedback 🙂.

Have a great day