Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alfredho
Contributor
Contributor

Creating new dataset

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.

SegmentsTypesReporting Month
AApple31Jan2019
AApple28Feb2019
AApple31Mar2019
AOrange31Jan2019
AOrange28Feb2019
AOrange31Mar2019
APear31Jan2019
APear28Feb2019
APear31Mar2019
BApple31Jan2019
BApple28Feb2019
BApple31Mar2019
BOrange31Jan2019
BOrange28Feb2019
BOrange31Mar2019
BPear31Jan2019
BPear28Feb2019
BPear31Mar2019
CApple31Jan2019
CApple28Feb2019
CApple31Mar2019
COrange31Jan2019
COrange28Feb2019
COrange31Mar2019
CPear31Jan2019
CPear28Feb2019
CPear31Mar2019

 

1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

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

View solution in original post

3 Replies
zhadrakas
Specialist II
Specialist II

can you share sample files for each dataset?
zhadrakas
Specialist II
Specialist II

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
Contributor
Contributor
Author

Thank you! Works like a Charm.