Hello QV community,
I have a question regarding linking Inline entered Dates to the Dates being pulled from the system.
I have manually entered some budget figures (Inline) that look like the below (last column '2018' is the Row total):
QUALIFY *;
UNQUALIFY "%KEY_*";
Budget_2018:
LOAD * INLINE [
%KEY_Cus_Id, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, 2018
300323, 0, 5000, 0, 0, 5400, 0, 0, 5400, 0, 0, 5400, 0, 21200
300449, 7000, 0, 7560, 0, 7560, 0, 7560, 0, 7560, 0, 7560, 0, 44800
];
D_Date:
LOAD "LINK_Date" as %KEY_Date,
Month("DATE_Date") as DateMonth;
SQL SELECT *
FROM "packaging_dwh_db".dbo."D_Date";
I would like to somehow link the Budget_2018 dates (e.g. Jan, Feb etc) with DateMonth. Please let me know if you have any suggestions on the best way to approaching this.
Thanks in advance!
Mo
