DM and class join

[#1]

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"

[ikomlyakov1929]

Hi, Govind!

You can make a key in both tables like

EXP_COST_ACCOUNT_CD + EXP_COST_SUBCATEGORY_CD as MyKeyForJoin

And than join!

[#3]

superb.I will check and let you know.Thanks