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

[Anonymous]

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 CODE	BRANCH
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 Code Description 132172 HAIR CLIPPER #HC70             1 132175 HAIR 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
DMA	INT228
EXP	INT235

[shraddha_g]

Can you share excel?

[marcus_sommer]

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

- Marcus