Union and to remove the blank in officename

Easley08 — Wed, 06 Mar 2024 02:21:14 GMT

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.

Re: Union and to remove the blank in officename

Anonymous — Thu, 07 Mar 2024 08:20:48 GMT

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.