topic Re: Creating new dataset in QlikView

Creating new dataset

alfredho — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Creating new dataset

zhadrakas — Thu, 25 Apr 2019 07:09:28 GMT

can you share sample files for each dataset?

Re: Creating new dataset

zhadrakas — Thu, 25 Apr 2019 07:16:57 GMT

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

Re: Creating new dataset

alfredho — Thu, 25 Apr 2019 08:40:37 GMT

Thank you! Works like a Charm.