topic Re: How to get column name (pivot table or table ) on load script editor ? in App Development

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

user_root — Wed, 22 Dec 2021 15:54:26 GMT

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?

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

lorenzoconforti — Wed, 22 Jan 2020 17:55:37 GMT

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

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

user_root — Mon, 16 Mar 2020 13:30:54 GMT

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 🙂