You can append the unknown value in dimension table and link it with Fact table key
LOAD * inline [
CostCenter as costcenterKEY
drop table CostCenterDimension;
if(isnull(costcenterKEY), 'Unknown', costcenterKEY
Thanks Tracy and Kushal for your quick and helpful replies!
I used a sort of combo of both your replies.
I'm not familiar with the AutoGenerate statement Tracy. Does it mean in this case that it only adds 1 row?
And if I replace the '1' value with 10, it would add 10 rows (with the 'Unknown' value)?
I used an 'concatenate & inline' solution, but I wanted to get a nice record like;
Unknown | Unknown_CostCenter | 01-01-2016 | 31-12-9999 | Unknown ledger |
So I changed (added all columns) the inline-solution provided by Kushal a bit.
Yes Koos, Autogenerate(10) would produce 10 rows. Autogenerate is telling Qlikview how many rows the table should have. It is expecting a number but that can be derived from an expression inside the brackets.
IF you want to add extra columns to your single row then this is how I would do it.
'Unknown' AS Company,
'Unknown_CostCenter' AS Col2Name,
'01-01-2016' AS Col3Name,
'31-12-9999' AS Col4Name,
'Unknown' AS Col5Name,
'ledger' AS Col5Name