Creating new dataset

[alfredho]

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

[zhadrakas]

can you share sample files for each dataset?

[zhadrakas · Accepted solution]

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
]; 

[alfredho]

Thank you! Works like a Charm.