Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
james_kimani
Not applicable

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

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
2 Replies
shraddha_g
Not applicable

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

Can you share excel?

marcus_sommer
Not applicable

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

I think you need to transform your first table with The Crosstable Load‌.

- Marcus