Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to join these 2 tables below on date and currency.
I did a cast on time since it was a datetime field and just picked up first 10 characters.
Im sorry first time doing joins but how is it done in Qlikview? I can do it in SQL but when it comes to qlikview I have no idea?
Execution:
LOAD
last_liquidity,
time,
Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as date,
routing_instruction,
Turnover,
flag_Fills,
account_ref,
last_liquidity_ind,
algo_id,
client_id,
client_order_id,
currency,
destination,
exec_broker,
exec_id,
exec_type,
FROM
(qvd);
Left join(Execution)
LOAD
date,
currency,
rate_eur
FROM
(qvd);
Execution:
LOAD
last_liquidity,
time,
currency &'-'& Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as %Key
Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as date,
routing_instruction,
Turnover,
flag_Fills,
account_ref,
last_liquidity_ind,
algo_id,
client_id,
client_order_id,
currency,
destination,
exec_broker,
exec_id,
exec_type,
FROM
(qvd);
Left join(Execution)
LOAD
date&'-'& currency as &Key
rate_eur
FROM
(qvd);
did u try
Noconcatenate (Execution)
instead of left join? gives me wrong syntax
Qlikview default joins the column matching between the tables. If more than a column matches , it creates a synthetic key. You can avoid by aliasing any column ( A as AA).
Execution:
LOAD
last_liquidity,
time,
currency &'-'& Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as %Key
Left(timestamp(time, 'YYYY-MM-DD hh:mm:ss'),10) as date,
routing_instruction,
Turnover,
flag_Fills,
account_ref,
last_liquidity_ind,
algo_id,
client_id,
client_order_id,
currency,
destination,
exec_broker,
exec_id,
exec_type,
FROM
(qvd);
Left join(Execution)
LOAD
date&'-'& currency as &Key
rate_eur
FROM
(qvd);
Thank you