2 Replies Latest reply: Aug 22, 2016 6:17 AM by Govind Ramchetty RSS

    DM and class join

    Govind Ramchetty

      HI

      I am using qlik sense.

       

      Select

      "EXP_COST_ROLLUP_CD" as  "HIER_EXP_COST_ROLLUP_CD",

          "EXP_COST_ROLLUP_NM" as "HIER_EXP_COST_ROLLUP_NM",

          "EXP_COST_ACCOUNT_CD" as "HIER_EXP_COST_ACCOUNT_CD",

          "EXP_COST_ACCOUNT_NM" as "HIER_EXP_COST_ACCOUNT_NM",

          "EXP_COST_SUBCATEGORY_CD",

          "EXP_COST_SUBCATEOGRY_NM",

          "HIER6_CD",

          "HIER6_NM",

          "HIER7_CD",

          "HIER7_NM",

          "HIER8_CD",

          "HIER8_NM",

          "HIER9_CD",

          "HIER9_NM",

          "HIER10_CD",

          "HIER10_NM",

          "HIERARCHY_ID",

          "ENABLED_FLG"

      FROM "EXP_D_EXPENSE_HIERARCHY";

       

      Select

      "EXP_CLASS_CD",

        "EXP_DIVISION_CD",

        "EXP_COST_ROLLUP_CD",

        "EXP_COST_ACCOUNT_CD",

        "EXP_COST_SUBCATEGORY_CD",

      ......

      From FACT.

       

       

      I have to join(2 columns) like below how can i achieve this

       

       

      EXP_COST_ACCOUNT_CD=EXP_COST_ACCOUNT_CD and

      "EXP_COST_SUBCATEGORY_CD"="EXP_COST_SUBCATEGORY_CD"