Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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