Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 jenmclean
		
			jenmclean
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Here is my script:
InvoiceHistoryLineItem:
LOAD TIHLBRAND, 
     TIHLBRDCST, 
     TIHLCLSPRD, 
     TIHLNUMBRD, 
     TIHLNUMCST, 
     TIHLNUMINV, 
     TIHLNUMLIN, 
     TIHLOPCST, 
     TIHLOPDTE, 
     TIHLOPFET, 
     TIHLOPINNB, 
     TIHLOPQTY, 
     TIHLOPVNNB, 
     TIHLYRPRIN
FROM
(txt, utf8, embedded labels, delimiter is ',', msq);
Store * from InvoiceHistoryLineItem into [QVD\VH\InvoiceHistoryLineItem_2.qvd] (qvd);
Drop Table InvoiceHistoryLineItem;
I need to exclude one invoice number (4175709) with bad numbers using the TIHLNUMINV field. There are over 3M records so manually doing this is not an option.
How would I complete this?
Thanks in Advance!
 
					
				
		
 stephencredmond
		
			stephencredmond
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Is this not just as easy as putting a where clause into the load from the CSV:
...
FROM
(txt, utf8, embedded labels, delimiter is ',', msq)
Where TIHLNUMINV <> 4175709;
Regards,
Stephen
Stephen Redmond is author of QlikView for Developer's Cookbook
He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Maybe like
InvoiceHistoryLineItem:
LOAD TIHLBRAND, 
     TIHLBRDCST, 
     TIHLCLSPRD, 
     TIHLNUMBRD, 
     TIHLNUMCST, 
     TIHLNUMINV, 
     TIHLNUMLIN, 
     TIHLOPCST, 
     TIHLOPDTE, 
     TIHLOPFET, 
     TIHLOPINNB, 
     TIHLOPQTY, 
     TIHLOPVNNB, 
     TIHLYRPRIN
FROM
(txt, utf8, embedded labels, delimiter is ',', msq)
WHERE TIHLNUMINV <> 4175709;
Store * from InvoiceHistoryLineItem into [QVD\VH\InvoiceHistoryLineItem_2.qvd] (qvd);
Drop Table InvoiceHistoryLineItem;
 
					
				
		
 stephencredmond
		
			stephencredmond
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Is this not just as easy as putting a where clause into the load from the CSV:
...
FROM
(txt, utf8, embedded labels, delimiter is ',', msq)
Where TIHLNUMINV <> 4175709;
Regards,
Stephen
Stephen Redmond is author of QlikView for Developer's Cookbook
He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond
