null values

[smilingjohn]

Iam using below code in the script to tag all brands which has "Tdepartment" in it , along with this i  want eliminate null values

how do i include that in the below script .

if(WildMatch(VM_Model,'*Tdepartment*'),'Tdepartment Only') as Tdepart,

Thans in advance

[smilingjohn]

Hi Mandaugas

They are from different table

[smilingjohn]

Hi Anil after the loading of the script now it show completely null values as shown in the script ...

i dont see Tdepartment  at all .

[Anil_Babu_Samineni]

Would you able to share sample application?

[Anil_Babu_Samineni · Accepted solution]

Or Can you do Suppress Null value from dimension and Presentation tab may be??

[smilingjohn]

Hi Anil,

Yes suppressing works perfectly at the dimesion level ...

But still i wanted to confirm  that if i can suppress this values witin the expression in the edit script ?

If you think its not required then it fine ...

Thanks

[Anil_Babu_Samineni]

It's possible in script as well. If you would provide sample data we may help you. I would highly recommend you to Mark as helpful or correct answer if you got solution