first value

[raadwiptec]

Hi

My scenario  as below

My output is in a table box

I receive 2 Values kind of duplicate

for ex

Customer no | Date | Reciept No | Amount | product Number

100235 | 10/Mar/2010 | 22565 | 2.225 | EF2887817

100235 | 20/Mar/2010 | 22565 | 2.225 | EF2887817

The Data comes from current file and history file. I would like to display as one record as this is actually a duplicate but showing 2 different values because of the difference in dare.

[Chanty4u]

if u want to use one field  value

u can use  max(urdate field)   it will give u the updated values

[avinashelite]

you could add a expression to fetch the max date add show the same

max(Date)

or

aggr( max(Date), [Customer no] , [Reciept No] , Amount ,[product Number])

You cannot use expression in the table box ..so you need to reduce the data in the script level

Source:

LOAD *

from

table;

Noconcatenate

result:

LOAD [Customer no],

max( Date),

[Reciept No],

[Amount] ,

[product Number]

resident

source

group by

[Customer no],

[Reciept No],

[Amount] ,

[product Number];

drop table Source;