How to put function in set analysis

[#1]

Hi

i want to pull out the MemberID while AuditInsertDate is max one , i used many function but it is not working well

max

({$<AuditInsertDate={'<$(= max(AuditInsertDate)'}>} Member_id

)

anyone know hot to do it

[perumal_41]

Hi,

Try this Expression

max

({$<AuditInsertDate={'<$(= max(AuditInsertDate))'}>} Member_id

)

[#3]

Hi there,

I used the following:

Max({<AuditInsertDate={$(=Max(AuditInsertDate))}>} Member_id)

Leo

[#4]

not working!

datatable like this

		MemberId	AuditInsertDate
		2186	6/28/2012 10:48:36
		2186	6/28/2012 10:51:08
		2186	6/29/2012 12:48:57
		2186	6/29/2012 12:52:17
		1941	6/29/2012 16:50:00

[perumal_41]

Hi ,

If possible upload sample Application

Regards

Perumal A

[#6]

try this

Max({<AuditInsertDate={$(=Max(timestamp#(AuditInsertDate,'YYYY-MM-DD hh_mm'))}>} Member_id)

Thanks

priyanka

[#7]

Hi max,

Just curious, can you do that during loading?

Regards,

Xue Bin