Discussion board where members can get started with Qlik Sense.
In my load script I first load a Fact table and 10 dimension tables.
How can I in the load script create a new table, which is a subset of the total "FactDimension" table based on values in the dimension tables.
In SQL, it would be something like:
Select * from Fact
left join ....
where dim1.fieldA = "aaa" and dim2.fieldB = "bbb" and ...
How can i do this without having to join my Fact table and the 10 dimension tables in the load script.
In other words, how can I in the load script filter data in the same way as when the load script is completed and data is loaded into Qlik Sense.
Thank you in advance for all ideas.
here is a simple sample script, is this what you are looking for?
load * inline
Bob Johnson,Washington D.C.
RecId as FactId,
RecDate as FactDate,
RecDealer as Dealer,
RecCustomer as Customer,
RecAmount as FactAmount
where exists (Dealer,RecDealer)
and exists (Customer,RecCustomer);
May be check out Exists function
Exists - script function ‒ QlikView
You can also look into Left Joins or Left Keeps
Understanding Join, Keep and Concatenate