Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 danielnevitt
		
			danielnevitt
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have the below script and I would like to sql union them together.
Is that possible? I know I need to add some 'null as' field to both parts for it to work correctly.
Any help will be much appreciated.
Regards,
Daniel
LOAD invoice_ref,
 value_date,
 invoice_co_id,
 partyad_id,
 DTLS_AMOUNT,
 currency_id,
 DTLS_PAYMENT_RECEIPT_IND,
 notes,
 ReportDate
 FROM
 [\\rosie\compliance\QlikView\Accounts Receivable\Unallocated*.qvd]
 (qvd);
 
 LOAD currency_id, 
 USDExchangeRate
 FROM
 [\\rosie\compliance\QlikView\Accounts Receivable\CurrencyConverter.xlsx]
 (ooxml, embedded labels, table is Sheet1);
 
 
 ODBC CONNECT32 TO [IQ CLONE];
 
 SQL SELECT voucher_num,
 pay_due_dt,
 internal_co_cd,
 co_cd,
 amount_due_in_pay_curr,
 pay_curr_cd,
 voucher_type_ind,
 operator_initials,
 amount_paid 
 
 FROM "tempest_tier1"."v_VOUCHER"
 where (amount_paid is null or amount_paid = 0)
 and amount_due_in_pay_curr <> 0; 
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
actually there are 3 different loads/selects in your script.
To concat the tables into one resulting table, you would just add a "Concatenate" prefix to each subsequent load/select to force concatenation.
hope this helps
regards
Marco
