topic Re: Primary Key extracted 1:N in App Development

Primary Key extracted 1:N

mateusgerin — Sat, 16 Nov 2024 20:08:56 GMT

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

Re: Primary Key extracted 1:N

saminea_ANZ — Wed, 04 Sep 2019 01:58:25 GMT

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;

Re: Primary Key extracted 1:N

Seyko — Wed, 04 Sep 2019 09:48:42 GMT

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.