Complicated output - Help required

[jpjust]

Hi All,

If some one can help me would be much appreciated.

Here is my raw output below from the script.

From the above, I am looking for an output like the below as single record (Basically the highlighted ones from above)

I want to achieve this by writing  expression on the front end rather than on the load script.

I tried expressions such as Max etc., but did not work.

Thanks for taking time to look into this.

[MarcoWedel]

Please post some sample values as text and specify the logic that defines the expected result.

thanks 

[jpjust]

Hi Marco,

Thank you for the initiative to help here.

I have attached the sample qvf itself to make it clear. This is based off an monitoring app and I am trying to bring a bit more info from Analysis script.

Please look at the Analysis sheet and I filtered out for App Names.

Following is the output I expect for TEST and TEST(w)

Basically, the Max Analyzed Date for the App Name should get aligned with AppName that don't have (1)

The app list are those published today. For that I use an expression like this - =Aggr(Only({<[App Publish Date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}[AppName]),[AppName])

Desired output

Please let me know if this is some thing doable.

Thanks very much!!