Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
I have two views, which I wish to use within the qlik sense environment...
one is DailyOrders, which is a view which brings back....Daily orders of every customer...and OrderDate are 01/01/2014, 02/01/2014 and so on
Other is MonthlyOrders which is a view which brings back....weekly orders of every customer ... and OrderDate are 01/01/2014, 01/02/2014 and so on
these two tables have exactly the same fields names...
my current app and its charts contained within just looks at the MonthlyOrders,
I wish to now join the DailyOrders
I understand making a fact table will be best... but how
please advise
Concatenate view 1 with 2
Orders:
LOAD
"Daily" AS "OrderType",
rest of your fields...
.
.
FROM Daily Orders View
CONCATENATE
LOAD
"Monthly" AS "OrderType",
rest of your fields...
.
.
FROM Monthly Orders View
This way all your order facts are sourced from one table.
Hiya
the issue I have is the views are from a SQL server
adding "Monthly" AS "OrderType",
I get an error... as you would is there a way of adding these fields manually in Qlik sense in without adding the to the SQL database?
Please help
Yes
'Monthly' AS "OrderType", should do it in your data load.