Choose Minimum Value OR Remove Max Value

[#1]

Hi Guys,

I have a bit of a tough question....i think The reason this is difficult is that there are a few conditions that need to be satisfied before any manipulation can happen on my table. I have attached an example with some test data.

I don't expect anyone to be able to provide me with the full solution, but if you can point me in the right direction in terms of how I should approach this/functions to use, would be much appreciated

Regards,

Byron

[kaushiknsolanki]

Hi,

   There is no test file. Please upload it again.

Regards,

Kaushik Solanki

[#3]

Just uploaded, cheers

[#4]

A post to keep this active. Hopefully someone will take the time to assist me here.

[#5]

Another post to keep active

[#6 · Accepted solution]

Hi,

As you requested the attached sample is going to help you giving a direction rather than complete solution.

Try to use peek or previous functions, try to add flags, try to do group by and all in the load script to achieve your requirement.

Please see the attached, where in i can see the scenario 1 and 2 are almost achieved.

Cheers.

[#7]

Hi BlackRockS

Still going through your reply but this looks fantastic. U put a lot of effort in and I appreciate that

Thank you very much
Byron

[#8]

Good it helped you for the time i spent.

Cheers.