Pivot table Max date

[nvijay5757]

Hi ,

in pivot table how to take max date

ex: 

in original ppap column as end_date. in this some rows are showing two to three dates how to take max date. if i apply MAX(date) not working. 

LOAD Distinct site_code,
Concat(DISTINCT part_description,', ') as Part_descriprion_new,
date(Max(end_date), 'YYYY-MM-DD') as end_date, 1 as date_flag
Resident Input Group By site_code;

i have written in script but all is grouping then it is showing only one site code. help me thanks.

[BrunPierre]

Maybe like this

TEMP:
LOAD Distinct site_code,
Part_descriprion_new,
end_date,
1 as date_flag
Resident Input;

FINAL:
LOAD site_code,
date_flag,
Concat(DISTINCT part_description,', ') as Part_descriprion_new,
Max(Date(end_date),'YYYY-MM-DD') as end_date
Resident TEMP
Group By site_code,date_flag;

DROP Table Input;

[nvijay5757]

Hi thanks for your reply,

above load i have used      Left Join( Input).

so if take resident then remaining cols missing.

[BrunPierre]

@nvijay5757 Sorry, I didn't quite catch what you said.

[BrunPierre]

@nvijay5757 Is your question answered?