How to get column name (pivot table or table ) on load script editor ?

[user_root]

Hi everyone, 

I want new dimension with pivot column names. 

Exm ; 

Example Table ; 

Headers:
LOAD * INLINE [
KPI, Header
KPI 1 &Chr(10)& CCC,KPI 1
'KPI 1'& Chr(10) & 'CCC(Region)', 'KPI 1'
'KPI 2'& Chr(10) & 'Warranty','KPI 2'
'KPI 2'& Chr(10) & 'Warranty (Region)','KPI 2'
'KPI 3'& Chr(10) & 'CC','KPI 3'
'KPI 3'& Chr(10) & 'CC (Region)','KPI 3',
'KPI 4'& Chr(10) & 'Accessories','KPI 4'

];

KPI : My Pivot Column Names

Header : Group Names

But  I don't get pivot column names on Load Script Editor  Headers Inline Table.

Can you help me pls? 

[lorenzoconforti]

What is not working? Can you share a clear example of what you are trying to achieve?

[user_root]

Hi Lorenzo, 

Basicly, I tried  two table column names and  using nested if  clause with column name pivot table merge column header. 

So , it's solved. Thanks 🙂