diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4746c154..3ce7d84a 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1106,7 +1106,8 @@ SELECT citco_reports.period_end_date, citco_reports."quantity(end)", citco_reports.bloomberg_code, citco_reports.symbol, - citco_reports.strategy, + split_part(citco_reports.strategy,'/',1) as Port, + split_part(citco_reports.strategy,'/',2) as Strat, citco_reports."prime_broker/clearing_broker", citco_reports.subfund, citco_reports.cusip, @@ -1132,7 +1133,8 @@ SELECT citco_reports.period_end_date, citco_reports."quantity(end)", citco_reports.bloomberg_code, citco_reports.symbol, - citco_reports.strategy, + split_part(citco_reports.strategy,'/',1) as Port, + split_part(citco_reports.strategy,'/',2) as Strat, citco_reports."prime_broker/clearing_broker", citco_reports.subfund, citco_reports.cusip, |