Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Script help

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;

1 Reply
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