Firstsorted value

[Anonymous]

Date	product	max days	Number
07/21/2017	7700550007000100	3	654582-002
07/21/2017	7700550007000100	3	729871-001
07/21/2017	7700550007000100	3	773911-002
07/21/2017	7700550007000100	3	777321-001
07/22/2017	7700550007000100	3	654582-002
07/22/2017	7700550007000100	3	729871-001
07/22/2017	7700550007000100	3	773911-002
07/22/2017	7700550007000100	3	777321-001
07/23/2017	7700550007000100	3	654582-002
07/23/2017	7700550007000100	3	729871-001
07/23/2017	7700550007000100	3	773911-002
07/23/2017	7700550007000100	3	777321-001

4 numbers are  blocking each date and days also same but i want output below one

654582-002,729871-001, 773911-002, 777321-001  in script level

[sunny_talwar]

Those numbers with which date? 7/23/2017 or 7/21/2017? If it is 7/23... you can try this

Fact:

LOAD Date,

     Product,

     [max days],

     Number

FROM ....;

Right Join (Fact)

LOAD Number,

     Max(Date) as Date

Resident Fact

Group By Number;

[Peter_Cammaert]

Can you post an example (in a table) of the expected output, based on your example data?

[Anil_Babu_Samineni]

May be this? I know, This is weird solution but result may give

SET DateFormat='MM/DD/YYYY';

And expression this?

Only({<Date = {'$(=Min(Date))'}>} Number)

And As Sunny Suggested, I believe Min(Date) can sort rather Max(Date)

[its_anandrjs]

In Script part try this ways

Data:

LOAD Date(Date#(Date,'MM/DD/YYYY'),'MM/DD/YYYY') as Date,product, [max days],Number  Inline

[

Date, product, max days, Number

07/21/2017, 7700550007000100, 3, 654582-002

07/21/2017, 7700550007000100, 3 ,729871-001

07/21/2017, 7700550007000100, 3 ,773911-002

07/21/2017, 7700550007000100, 3, 777321-001

07/22/2017, 7700550007000100, 3, 654582-002

07/22/2017, 7700550007000100, 3, 729871-001

07/22/2017, 7700550007000100, 3, 773911-002

07/22/2017, 7700550007000100, 3, 777321-001

07/23/2017, 7700550007000100, 3, 654582-002

07/23/2017, 7700550007000100, 3, 729871-001

07/23/2017, 7700550007000100, 3, 773911-002

07/23/2017, 7700550007000100, 3, 777321-001

];

NewTable:

LOAD

Date,product,[max days],

Concat( Number,',') as New

Resident Data Group By Date, product, [max days];

DROP Table Data;

Output

[vishsaggi]

Hello Anand, Did you put the output from a different qvw? Does not match the data in the LOAD statement. Just FYI.

[its_anandrjs]

Thanks i change this now please check earlier i was trying to update but it not get update now it is changed.

[vishsaggi]

Thumbs Up!!