Check if value exists within group

[nigel987]

Hi,

I have several IDs and Date. Whenever the same Date occurs more than once within a group, I'd like to set the field Bulk as 'Yes', else 'No'.

Any idea which formula I can use? With peek I always miss the first entry.

Here's an example how the result should look like:

ID	Date	Bulk
1	15.10.2017	Yes
1	15.10.2017	Yes
1	16.10.2017	Yes
1	16.10.2017	Yes
1	20.10.2017	No
2	15.10.2017	No
2	16.10.2017	Yes
2	16.10.2017	Yes
2	20.10.2017	No

Thanks for any hint!

[sunny_talwar · Accepted solution]

May be this:

Left Join (Table)

LOAD ID,

           Date,

          If(Count(Date) >= 2, 'Yes', 'No') as Bulk

Resident Table

Group By ID, Date;

[nigel987]

Thanks!