Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankit1911
Partner - Contributor
Partner - Contributor

How can I fetch only the latest records?

Hi Everyone,

I have the following fields in the table, with the single or multiple records for each of the %Sales_Key.

Ankit1911_0-1692853819995.png


I want the latest record for each of %sales_key; There have been multiple sales reported for each %Sales Key;
But Need to fetch the latest one at the script level Like below :

Ankit1911_1-1692854034581.png


Thank you for your help.




Labels (3)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Hi as below

Data:
LOAD %Sales_Key,
Date,
Sales
FROM ...;

Inner Join
LOAD %Sales_Key,
Timestamp(Max(Date)) as Date

Resident Data
Group By %Sales_Key;

View solution in original post

3 Replies
BrunPierre
Partner - Master
Partner - Master

Hi as below

Data:
LOAD %Sales_Key,
Date,
Sales
FROM ...;

Inner Join
LOAD %Sales_Key,
Timestamp(Max(Date)) as Date

Resident Data
Group By %Sales_Key;

Tanish
Partner - Creator
Partner - Creator

Hi Ankit, 

Let me tell you the simplest way to achieve this result.

Create a Table 

1. Add Dimension - %Sales_Key

2. Add Measure - Max(Date)

3. Add Sales as Dimension not measure.

You will get your result....

 

Thanks,

Tanish 

 

Ankit1911
Partner - Contributor
Partner - Contributor
Author

Thank you!
It's working.