how to get latest value from every group ?

[Akina0929]

I have product code ,product name

             001,pen

            002,pen

          003,pen

         004,paper

         005,paper

expected output should be follows

product code,product name

003,pen

005,paper

thanks

[sunny_talwar]

Is this something you want in the script or front end? For front end, try this

Dimension

product name

Expression

Max([product code])

[Raghul]

One way of doing is to use Mapping and ApplyMap () function in Data load script using a Flag as shown below.

Then add the dimension (Object) and Measure (If(Flag = 1, Value, NULL)). And exclude the NULL values.

Note: This is sample method, you can also try different options.

[Akina0929]

only one value getting for all products

[sunny_talwar]

Which approach did you try?