topic Re: max value of Modified date in App Development

max value of Modified date

Raju_6952 — Wed, 10 Jan 2024 09:38:38 GMT

Hi,

I have data in the following manner, the request to load only value for the max (modified date) or latest modified date.

Please let me know if any suggestions.

Re: max value of Modified date

Parthiban — Wed, 10 Jan 2024 10:01:56 GMT

Hi,

First load the table and then take max(modified_Date) and store that field in the vaiable using peek function.

and then you load the original script and use where condition modified_date=$(variable).

Then you will get max date data in your script.

Re: max value of Modified date

Raju_6952 — Wed, 10 Jan 2024 11:45:39 GMT

I tried this way but giving blank value for other fileds except primary key.

Re: max value of Modified date

Parthiban — Wed, 10 Jan 2024 12:20:59 GMT

Hi,

Cross check the data format in where condition

Re: max value of Modified date

Anil_Babu_Samineni — Wed, 10 Jan 2024 13:59:01 GMT

@Raju_6952 how about this?

mytable:

Load *, Modifieddate From <<YourTable>>;

minmax:

LOAD

min(Modifieddate) as MinDate,

max(Modifieddate) as MaxDate

RESIDENT mytable;

LET vMinDate = peek('MinDate'); // This is to capture the minimum date

LET vMaxDate = peek('MaxDate); // This is to capture the maximum date

DROP TABLE minmax;

Final_mytable:

NoConcatenate

Load * Resident mytable where Date(Modifieddate)=Date('$(vMaxDate)');

Re: max value of Modified date

Raju_6952 — Fri, 12 Jan 2024 04:58:01 GMT

Hi @Anil_Babu_Samineni ,

Tried this but no use.

Thanks,

Raju

Re: max value of Modified date

Rohan — Fri, 12 Jan 2024 06:07:37 GMT

Hi @Raju_6952 ,

Try this :

DateMap:

Mapping load *;

Load PrimaryKey,max(date(date#(ModifiedDate,'DD.MM.YYYY'))) as Max

Resident Data group by PrimaryKey;

Noconcatenate

Final:

Load *

Resident Data where date(date#(ModifiedDate,'DD.MM.YYYY'))=Applymap('DateMap',PrimaryKey,'N/A');

Drop table Data;

Regards,

Rohan.

Re: max value of Modified date

Anil_Babu_Samineni — Fri, 12 Jan 2024 08:57:11 GMT

@Raju_6952 When you say no use, IS this you mean failed? or, Data not coming as expected or what is exact issue?

Re: max value of Modified date

Raju_6952 — Fri, 12 Jan 2024 09:12:01 GMT

Hi @Anil_Babu_Samineni ,

I am not getting the correct values.

Thanks,

Raju

Re: max value of Modified date

Anil_Babu_Samineni — Fri, 12 Jan 2024 09:24:31 GMT

@Raju_6952 Please share sample dataset and expected result?

Re: max value of Modified date

Raju_6952 — Fri, 19 Jan 2024 08:06:32 GMT

Hi @Anil_Babu_Samineni ,

Please find the attached screenshot for your reference.

The requited output will be like need only the value for max of modified date.

Regards,

Raju

Re: max value of Modified date

Rohan — Fri, 19 Jan 2024 09:42:01 GMT

Hi @Raju_6952 , Can you share the script that you have used ?

Regards,

Rohan.

Re: max value of Modified date

Anil_Babu_Samineni — Sat, 20 Jan 2024 08:56:32 GMT

@Raju_6952 We appreciate sharing the data set (In the format of readable, example excel not image) with expected result what you need?