Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
Specialist II
Specialist II

can you share sample files for each dataset?
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

Contributor
Contributor

Thank you! Works like a Charm.