Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
demonioazul
Creator
Creator

Qlik Sense - Append columns with same info into one column at Load Script

H There,

I want to append measures C1, C2 and C3 into only one named Serial Number at Load Script. Is it possible?

2020-03-04 16_30_20-TTC-REC-200304.xlsx - Excel.png

 

2020-03-04 16_34_57-TTC-REC-200304.xlsx - Excel.png

 

Labels (1)
1 Solution

Accepted Solutions
_ylc
Partner - Creator
Partner - Creator

You just load them individually.

temp:
LOAD * INLINE [
C1, C2, C3
700-001, 12900-001, 12100-001
700-002, 12900-002, 12100-002
700-003, 12900-003, 12100-003
700-004, 12900-004, 12100-004
700-005, 12900-005, 12100-005
700-006, 12900-006, 12100-006
, 12900-007, 12100-007
, 12900-008, 12100-008
];

final:
LOAD C1 as [Serial Number] resident temp; //you can add where len(C1)>0 to remove null values
LOAD C2 as [Serial Number] resident temp;
LOAD C3 as [Serial Number] resident temp;

drop table temp;

 

Qlik will automatically concatenate the tables if it's having common field names.

View solution in original post

2 Replies
_ylc
Partner - Creator
Partner - Creator

You just load them individually.

temp:
LOAD * INLINE [
C1, C2, C3
700-001, 12900-001, 12100-001
700-002, 12900-002, 12100-002
700-003, 12900-003, 12100-003
700-004, 12900-004, 12100-004
700-005, 12900-005, 12100-005
700-006, 12900-006, 12100-006
, 12900-007, 12100-007
, 12900-008, 12100-008
];

final:
LOAD C1 as [Serial Number] resident temp; //you can add where len(C1)>0 to remove null values
LOAD C2 as [Serial Number] resident temp;
LOAD C3 as [Serial Number] resident temp;

drop table temp;

 

Qlik will automatically concatenate the tables if it's having common field names.

demonioazul
Creator
Creator
Author

Excellent!
Thank you, @_ylc , this is what I needed!
I guess I need to catch up with the last versions of Qlik Sense, I don't recall this was possible in earlier versions...

Anyway, I appreciate your time and help, it works!