Show excluded values for a given date

[Anonymous]

I have two tables.

Table A has 3 fields : ID, USER_ID and DATE

ID, USER_ID, DATE

01, uid_001, 01-01-2016

02, uid_002, 01-01-2016

03, uid_001, 02-01-2016

04, uid_003, 02-01-2016

05. uid_004, 02-01-2016

Table B has 2 fields : USER_ID and USER_NAME

USER_ID, USER_NAME

uid_001, user 01

uid_002, user 02

uid_003, user 03

uid_004, user 04

I need to display the users who are not available for a given date.

Ex: users uid_003 and uid_004 were not available on 01-01-2016

Can someone please guide me?

[lironbaram · Accepted solution]

Hi

have a look at the attach example

this expression will work in a table

Maxstring({<DATE=, USER_ID=e(USER_ID)>}USER_ID)

[Anonymous]

Hi Deshani,

Please refer the below Attached application for creating a table according to your requirements.

Hope this helps.

Thanks,

Balkamal Singh

[Anonymous]

Hi Liron,

Thank you! The expression was what I just needed. Thank you once again