Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hello,
I have a table like this:
| A | A-TEST | 
| C | TEST | 
| B | B-TEST | 
| C | C-TEST | 
I want to delete lines to get a table like this:
| A | A-TEST | 
| B | B-TEST | 
| C | C-TEST | 
When you have two lines with the same key (first column), just preserve the last one.
Can someone help me on this please?
Thanks,
Regards,
Loïc
 Clever_Anjos
		
			Clever_Anjos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		T:
LOAD F1,F2,-RecNo() as Ord INLINE [
F1, F2
A, A-TEST
C, TEST
B, B-TEST
C, C-TEST
];
LOAD
F1 as Final,
F2
Resident T
Where not Exists(Final,F1)
order by Ord;
drop table T;
 Clever_Anjos
		
			Clever_Anjos
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		T:
LOAD F1,F2,-RecNo() as Ord INLINE [
F1, F2
A, A-TEST
C, TEST
B, B-TEST
C, C-TEST
];
LOAD
F1 as Final,
F2
Resident T
Where not Exists(Final,F1)
order by Ord;
drop table T;
 
					
				
		
Also in Presentation Tab, Select the 'Final' column and check 'Omit Rows Where Field is NULL'.
