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

[MindaugasBacius]

May be this would help you:

if(WildMatch(VM_Model,'*Tdepartment*') or Len(Trim(VM_Model)) = 0,'Tdepartment Only') as Tdepart,

[Anil_Babu_Samineni]

I didn't understand your intend here. You already written the text search so you have some values with that. What you mean to remove the null values over here. May be use with OR Operator any one of below

If(Len(Trim(VM_Model))>0,VM_Model)

or

If(Len(Purgechar(VM_Model, chr(32) & chr(160)))>0,VM_Model)

[neelamsaroha157]

May be you can take resident of the table with a where condition: Where not isNull(Tdepart) or use this condition in precedence load.

[smilingjohn]

Hi Anil,

I want to remove the null values  also here .

[MindaugasBacius]

What do you mean by saying "remove"?

Do you need to remove them from your table or change null values to something?

[smilingjohn]

Anil please find the attachment

here if you look i am getting a null, values also , i dont know why it is aapearing two time one with  Tdepartment Only

(iPerformance Only) and exactly below that its null ,

so i want to remove the null values ...

i hope you understand it now ...

[Anil_Babu_Samineni]

May be this? and operator consider as If condition full fills it will returns

if(WildMatch(VM_Model,'*Tdepartment*') and If(Len(Trim(VM_Model))>0,VM_Model),'Tdepartment Only') as Tdepart,

[MindaugasBacius]

Are both dimensions from the same table?

Might be something wrong with joins in your data model.

[smilingjohn]

Anile i have kept you sugested script to run ( reloading )

can you please tell me what is this going to do ?