pull max date data during table extraction

[nareshthavidishetty]

Hi,

We need to extract only max date data during table extraction.

Thanks..

[Chanty4u]

1. temp: 
2. LOAD Date 
3. FROM [YourQVD.qvd] (qvd); 
4.  
5. MinMaxDate: 
6. Load min(Date) as MinDate, 
7.         max(Date) as MaxDate; 
8. Load FieldValue('Date',IterNo()) as Date 
9. autogenerate(1) 
10. while not IsNull(FieldValue('Date',Iterno())); 
11.  
12. Drop Table temp;

[Anil_Babu_Samineni]

How is your table file format? And explain clearly with sample files or this question related to data?

[balabhaskarqlik]

Maybe:

Use max(date), Peek() functions to get max date,

load the data on comparison with above max date.

load the data on Exist check with the main column data.