Primary Key extracted 1:N

[mateusgerin]

Hello All!!

Does anyone know how to achieve this result?

Database

Partner_Function	Business Partner_Number
A	11168033
B	8163122
C	8155562
A	8337550

Expected in QlikSense 

Partner A	Partner B	Partner C
11168033	8163122	8155562
8337550

[saminea_ANZ]

Perhaps this?

Expected Result:

Table:
CrossTable(Partner, Data)
LOAD Partner_Function,
A,
B,
C,
A1 as A
FROM
[Cross Table.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Transpose()
));

Temp:
NoConcatenate
LOAD Partner, Data, Partner_Function Resident Table;

DROP Table Table;

Partner:
Generic LOAD Partner_Function, 'Partner '&Partner, Num(Data) as Data Resident Temp;

[Seyko]

Good job to @saminea_ANZ . An other alternative @mateusgerin , the generic load. For example:

map_name:
MAPPING 
LOAD * INLINE [
Partner, Name
A,Partner A
B,Partner B
C, Partner C
]
;

GENERIC LOAD
1 AS Row_Num, // a flag field, because you need 3 fields minimum to execute generic load
*
;
LOAD * INLINE [
Partner_Function,Business Partner_Number
A,	11168033
B,	8163122
C,	8155562
A,	8337550
]
;
RENAME FIELDS USING map_name;

cordially.