Date division based on AM and PM

[iahmadmca1]

Team,

I just want to ask something regarding date division based on AM and PM as for example.

I have one date column like DATE which contains the both date like AM and PM I want to separate average of AM date and PM date.Please refer the below table for more details.

Date
01/02/2017 AM
01/03/2017 PM
01/04/2017 AM
01/05/2017 PM

Need to calculate the average of 01/02/2017 AM,01/04/2017 AM, and 01/03/2017PM,01/05/2017 PM both AM and PM average I need to calculate separate; could you please help me to do this requirement.

Thanks,

Irshad Ahmad

[Anonymous]

Like this??

load Pick(Flag,'AM','PM') as type,avg(Value) Group by Flag;

Load *,WildMatch(Date,'*AM*','*PM*') as Flag inline

[Date,Value

01/02/2017 AM,10

01/03/2017 PM,20

01/04/2017 AM,30

01/05/2017 PM,40];

[MK_QSL]

like this?

[iahmadmca1]

Thanks, Manish.