Discussion Board for collaboration on QlikView Scripting.
I have a model whose models eventually looks like this
LOAD Y, RC, BU, GEEWE
(ooxml, embedded labels, table is GLE);
LOAD Y, RC, BU, ILEWE
(ooxml, embedded labels, table is ILE);
LOAD Y, RC, BU, BEWE
(ooxml, embedded labels, table is BE);
And the tables are like
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
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' AS Type,
'ILE' As TYPE
BE As Type,
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.