Find minimum for each record

risabhroy_03 — Fri, 24 Jun 2022 04:58:56 GMT

I have to find minimum [Task No] for records based on "T$PITM" , "T$BPID", "T$TANO" , Company_Code.

My code is working fine for maximum but it is not working as expected for Minimum.

Below is my code for Maximum -

[Max_SEQN]:
Mapping
Load
"T$PITM" & '|' & "T$BPID" & '|' & "T$TANO" & '|' & Company_Code,
max("T$SEQN") as [Max_SEQN_Updated]
FROM [$(vSource)\TTIUIL160.qvd](qvd)
Group By
Company_Code,
"T$PITM",
"T$BPID",
"T$TANO";

And I am using the below inside my table -

if(ApplyMap('Min_SEQN',"T$PITM" & '|' & "T$BPID" & '|' & "T$TANO" & '|' & Company_Code,'-') = floor(num("T$SEQN")),1,0 ) as [Max_SEQN_Flag],

And I am using this like -

where [Max_SEQN_Flag]=1;

It works perfect.

Please help me to the same with Minimum, I replaced Max with Min but it is not coming correct.

Re: Find minimum for each record

MartW — Fri, 24 Jun 2022 10:22:31 GMT

did you change al the Max values to min, if so could you please als add the updated scripts

topic Find minimum for each record in App Development

Find minimum for each record

Re: Find minimum for each record