2 Replies Latest reply: Oct 21, 2016 7:20 AM by Marcus Sommer RSS

    how to create association of two table with one primary key data in column and the other one in row

    James Kimani

      how to create association of two table with one primary key data in column and the other one in row

      i am new to qlik.

      i have tow tables in excel which i want to link data, i have thr primary key data in one table in columns and the other one in row format.

       

      kindly advice.

        

      OUTLET CODEBRANCH
      ANS INT297

                                                 

      DMA PNR HKT ATH EXP MSC MSS ONR WRG ESL IMA OTC CHN CRE UTD CHP DGO BBA HRX MID TMA NDO ADM MTP TGR EMB BDR SLH KLF LLG GSP ZIN MTP2 LBR MTS ONR2 ELGH THK RUAI MERU K/AVE RDA RNG
      CodeDescription
      132172 HAIR CLIPPER #HC70            1
      132175HAIR DRYER #DT1400        1
      134793 H/E#MN1500 B2 AA2 1.5V      26       81       18           3       16       50       55         40         10        20       54       36        7      22           68       15         20            28
      134794 L/L#MN1500 B2 AA2 1.5V       11       60       28       14         20            5
      134795 L/L#MN1500 B4 AA4 1.5V       40       26       73           2        35       38       62         10           8         23        40       89         3           70       33         13            10            34
      134796 L/L#MN2400B2 AAA2 1.5V    103       46       17        12       42         16         10           8           1      22      10         6         11
      134797 L/L#MN2400B4 AAA4 1.5V       47         4       18        54      18        24       20        25        59       41       49         57         10         11        42        39         4      32      27          1             1       17            5              2
      134800 RECHRG.#NI-MH AAA 800mAh         1
      CHN INT224
      THK INT225
      MERU INT248
      OLT INT285
      JUJA INT299
      HRX INT237
      MSC INT246
      MID INT249
      BFL INT295
      MLE INT298
      MTV INT300
      STR INT301
      UTHRU INT290
      MTS INT291
      DMAINT228
      EXP INT235