Linking Inline Dates within Script? Please help

[Anonymous]

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

[neelamsaroha157]

Use of cross table might be your solution, if I am understanding your requirement correctly.

The Crosstable Load