Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser201
Creator II
Creator II

Data Load editor - Create 3 columns from a already existing single column

I need to create 3 different sub-columns from single column. 

 

This is my sample data

Company codeAttributed fields
AAManager
AACIO
AAIT Lead
AADev Lead
AAIT Staff
AADev Staff
ABManager
ABCIO
ABIT Lead
ABDev Lead
ABIT Staff
ABDev Staff

 

 

I need output something similar to this.

CompanyLevel 1Level 2Level 3
AAManagerIT LeadIT Staff
AACIODev LeadDev Staff
ABManagerIT LeadIT Staff
ABCIODev LeadDev Staff

 

Level 1:

Company Name,

Attributed fields as Level1

If Attributed fields = Manager, '1' if  Attributed fields  = CIO, '2', as Key1

Resident

Sample Table

Level 2:

Company Name,

Attributed fields as Level2,

If Attributed fields = IT Lead , '1', If Attributed fields = Dev Lead , '2' as Key2

Resident

Sample Table

Level 1 and Level 2 Join:

Load

Company Name & Key1 as Key3

 Level1

Resident

Level 1

Inner join

Company Name & Key2 as Key3,

Level2,

Resident

Level 2

I got output something like this.

CompanyLevel 1Level 2
AAManagerIT Lead
AACIODev Lead
ABManagerIT Lead
ABCIODev Lead

But I'm not sure how to proceed further

2 Replies
jwjackso
Specialist III
Specialist III

Have you looked at Henric's Generic Load ?

Qlikuser201
Creator II
Creator II
Author

Yes, However, my input table is itself a crosstable Data, so if i did generic load i may get something similar to this,

AAManagerCIOIT LeadDev LeadIT StaffDev Staff