Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nedcliqs
New Contributor III

Synthetic keys - removal

Hi Community

I have a model whose models eventually looks like this


      

GLE:

LOAD Y, RC, BU, GEEWE

FROM ***

(ooxml, embedded labels, table is GLE);

ILE:

LOAD Y, RC, BU, ILEWE

FROM ***

(ooxml, embedded labels, table is ILE);

BE:

LOAD Y, RC, BU, BEWE

FROM ***

(ooxml, embedded labels, table is BE);

And the tables are like

          

skeys.JPG

The model was giving the expected results until now.

I need to get rid of the synthetic keys


May you please help by way of an example with a simple LOAD inline

Tags (1)
1 Reply
mark6505
Valued Contributor III

Re: Synthetic keys - removal

HI,

Hard to give the correct advised not knowing what the data is, assuming that the field contain the same data i would approach like the below.

GLE:

LOAD

'GLE'     AS Type,

Y,

RC,

BU,

GEEWE

FROM ***

(ooxml, embedded labels, table is GLE);

Concatenate

ILE:

LOAD

'ILE'      As TYPE

Y,

RC,

BU,

ILEWE

FROM ***

(ooxml, embedded labels, table is ILE);

Concatente

BE:

LOAD

BE As Type,

Y,

RC,

BU,

BEWE

FROM ***

(ooxml, embedded labels, table is BE);

This will give you one fact table with a type to restrict the information to the source table.

If this is not what you are after then you will need to alias all the field in the table that are not the Key.

Mark

Community Browser