Union and to remove the blank in officename

[Easley08]

Hi,

would like to ask on how can i union this two table sample for the fact table the Officename is blank 

and i want to get all the office name from the LKP table so i Union the two tables but in the result i am getting two with the blank officename 

how to get only Office name with London in the Merge table. 

thanks.

[Anonymous]

Hi @Easley08 ,

Not quite sure what you intend, but failing the filter about London from the expression, please try adding it.

Please feel free to correct me and provide more information if I have misunderstood you!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.