Arrange raw data table in to a list and dropping some fields

[tinkerz1]

Hi,

This going to be hard to explain.

I have made a QVW, with an example.

The raw data has one to many relationships when a new issue is logged, there can be serveral actions relating to solving one issue.

When this information is presented to the forum we only need the original Issue and each action following on from that.

Also due to the database, any changes in a field not needed by the forum, a new line will created and exported to create the raw data. so I just need the last action field, an action is defined by and Action ID, I will still need all Actions per issue to be presented to the forum.

The output will be below, can anyone help me drop the issues I dont need from the 'crosstable from rawdata' straight table.

Its Issue ID 2 and Issue ID 4.

Thanks,

Field	Value
Issue - ID	1
Issue - Title	Dull Report
Issue - Owner	Mr M
Action - ID	1
Action - Title	Fixed Dullness
Action - Owner	Mr M
Issue - ID	2
Issue - Title	Good Report
Issue - Owner	Mr F
Action - ID	1
Action - Title	Fixed Formatting
Action - Owner	Mr F
Action - ID	2
Action - Title	Fixed datafeed
Action - Owner	Mr G
Issue - ID	3
Issue - Title	Length of Report
Issue - Owner	Mr S
Action - ID	1
Action - Title	Fix length
Action - Owner	Mr B
Issue - ID	4
Issue - Title	Incorrect datafeed
Issue - Owner	Mr Y
Action - ID	1
Action - Title	Fix database
Action - Owner	Mr S
Action - ID	2
Action - Title	Fix database again
Action - Owner	Mr Y

[tinkerz1 · Accepted solution]

Ok solved

surpress zero values and make 2 expressions

=aggr(count(Field),Value,Field)

if(Field='Action - ID',1)

group by using 'only' in the load clause on the Issue-ID

Then the list will drop on duplicates in the Issue ID field but keep the sort order