Hi all,
I would appreciate some help with the below data load.
I' struggling to create a field joining so.operating_desk_cd (from the sql) and CommodityGroup (from the first xlxs table). I would like to name this Join2 and then join with the second xlxs table.
Regards,
Daniel
LOAD *,
first_name & ' ' & last_name as trader_name,
office_cd & ' ' & desk_cd as office_desk_cd,
trade_type_group_cd&'-'&cmdty_cd as Join;
select distinct atr.hdr_num, atr.pcr_num, atr.bfc_cd, atr.co_cd,atr.exchange_cd, atr.strategy_num,atr.trade_dt, atr.trade_num, atr.trade_status_ind, atr.trade_type_group_cd, atr.trader_initials, bs_ind, atr.cmdty_cd,
so.desk_cd, so.office_cd, so.operating_desk_cd
from tempest_tier1.p_edw_trade_all('Non-US','Crude','%','%','%','%','Trade Dt','2023-09-01','2050-12-31','%','Today','Trade',0) atr
left join tempest_tier1.v_STRATEGY_OWNER so on (so.strategy_num = atr.strategy_num)
Where atr.trade_status_ind not in ('C');
LOAD [Trade Type],
Commodity,
CommodityGroup,
Join
FROM
[K:\KPI Dashboards\Trader Mandates\Product Mapping.xlsx]
(ooxml, embedded labels, table is Products);
LOAD operating_desk,
[TradeType],
Mandate,
Join2
FROM
[K:\KPI Dashboards\Trader Mandates\Product Mapping.xlsx]
(ooxml, embedded labels, table is Mandates);
