Max date

[tsachdev421]

I want to update all the rows in date column with Max date 

[durgesh22]

@tsachdev421 

try below code

Temp1:

load * Inline [
Name, Date
John,
Kim,19/02/2021
Rick,
Marin,
Oscar,12/02/2021
];
NoConcatenate
Temp2:
load Date(Max(Date#(Date,'DD/MM/YYYY')),'MM/DD/YYYY') as NDate Resident Temp1 ;
//drop Table Temp1;
let maxdt=peek('NDate',0,'Temp2');
trace $(maxdt);
Final:
load Name,'$(maxdt)' as Date11 Resident Temp1;
drop Table Temp1,Temp2;

Thanks

[durgesh22]

if you are trying to achieve this in Table chart then try below.

Date(Max(total Date#(Date,'DD/MM/YYYY')),'DD/MM/YYYY')

[tsachdev421]

This is not working. Giving null in all the rows.

[Aditya_Chitale]

@tsachdev421 

Try this:

test1:

LOAD
Name,
Date("Date",'DD/MM/YYYY') as Date2,
'1' as Flag
FROM [...]

left join (test1)

test2:

load
Flag,
max(Date(Date2,'DD/MM/YYYY')) as Date
Resident test1
group by Flag;

Drop field Date2 from test1;

Regards,

Aditya

[vinieme12]

temp:

load Name,Date#(Date,'DD/MM/YYYY') as DateCol Inline [
Name,Date
John,
Kim,19/02/2021
Rick,
Marin,
Oscar,12/02/2021
];

left join(temp)
LOAD
date(max(FieldValue('DateCol', recno()))) as maxdate
AUTOGENERATE FieldValueCount('DateCol');

drop field DateCol;
rename field maxdate to DateCol;

exit Script;