Joins

[Giwa_Temitopoluwa]

how can I remove duplicates from this table based on the first field?

[Lakshminarayanan_J]

Hi @Giwa_Temitopoluwa 

Try using Distinct (HRdataset_V9.Employee) , if not working try removing the null value check in the expression

Thank You!

[sidhiq91]

@Giwa_Temitopoluwa I think you can uncheck include Null Values in the 2nd Dimension in the straight table.

[Mark_Little]

HI @Giwa_Temitopoluwa 

Quickest answer as suggested by @sidhiq91 ,

I would be tempted to look into the data model to find out why you have duplicates when you are not expecting them.