Script help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: Script help

MarcoWedel — Wed, 09 Nov 2016 20:49:22 GMT

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

topic Script help in QlikView

Script help

Re: Script help