Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;
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.