Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have 3 different datasets Segments, Reporting Month, Types
Segments - A, B, C
Reporting Month - 31Jan2019, 28Feb2019, 31March2019
Types - Apple, Orange, Pear
and would like to use the load script to create the following table. How can i achieve that? Thank you.
Segments | Types | Reporting Month |
A | Apple | 31Jan2019 |
A | Apple | 28Feb2019 |
A | Apple | 31Mar2019 |
A | Orange | 31Jan2019 |
A | Orange | 28Feb2019 |
A | Orange | 31Mar2019 |
A | Pear | 31Jan2019 |
A | Pear | 28Feb2019 |
A | Pear | 31Mar2019 |
B | Apple | 31Jan2019 |
B | Apple | 28Feb2019 |
B | Apple | 31Mar2019 |
B | Orange | 31Jan2019 |
B | Orange | 28Feb2019 |
B | Orange | 31Mar2019 |
B | Pear | 31Jan2019 |
B | Pear | 28Feb2019 |
B | Pear | 31Mar2019 |
C | Apple | 31Jan2019 |
C | Apple | 28Feb2019 |
C | Apple | 31Mar2019 |
C | Orange | 31Jan2019 |
C | Orange | 28Feb2019 |
C | Orange | 31Mar2019 |
C | Pear | 31Jan2019 |
C | Pear | 28Feb2019 |
C | Pear | 31Mar2019 |
check this script (replace inline Load with your load Statements)
TEST: //segments LOAD * INLINE [ Segments A B C ]; //Reporting Month outer join LOAD * INLINE [ Month 31Jan2019 28Feb2019 31March2019 ]; //Types outer join LOAD * INLINE [ Types Apple Orange Pear ];
check this script (replace inline Load with your load Statements)
TEST: //segments LOAD * INLINE [ Segments A B C ]; //Reporting Month outer join LOAD * INLINE [ Month 31Jan2019 28Feb2019 31March2019 ]; //Types outer join LOAD * INLINE [ Types Apple Orange Pear ];
Thank you! Works like a Charm.