Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create 3 different sub-columns from single column.
This is my sample data
I need output something similar to this.
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:
Attributed fields as Level2,
If Attributed fields = IT Lead , '1', If Attributed fields = Dev Lead , '2' as Key2
Level 1 and Level 2 Join:
Load
Company Name & Key1 as Key3
Level1
Level 1
Inner join
Company Name & Key2 as Key3,
Level2,
Level 2
I got output something like this.
But I'm not sure how to proceed further
Have you looked at Henric's Generic Load ?
Yes, However, my input table is itself a crosstable Data, so if i did generic load i may get something similar to this,
