IF NOT MATCH function - help

[michak80]

Hello, 

below you can see the table where exist some transactions. My problem is that I do not want to see transactions where ITL_FROM_LOC_ID is CONTAINER. As you can see, I try to use "if not match" but it doesn't work for me because I still see this line but with (-). 

Is it possible to recieve data without these transactions? 

[Saravanan_Desingh]

Please use the 'If(Not Match' in your Dimension. Not in the Expression.

[michak80 · Accepted solution]

Hello @Saravanan_Desingh 

thank you for sugestion but honestly speaking it's not clear for me 😞

I'm using table and added column "Dimention" 

However, I think I found solution. I unmarked flag "Include null values" and  I got what I need.