Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
if u want to use one field value
u can use max(urdate field) it will give u the updated values
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;