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
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
onkarkulkarni
Creator
Creator

change table header for different columns

Hello experts,

My dashboard data source is excel file. I have few columns for which I have to refer 2nd row as header,rest 1 st row.

Can you help to guide how can read all the columns.

Regards,

Onkar Kulkarni

2 Replies
rajkumart
Partner
Partner

In General You can not access as header for the multiple Row either you need deal in Excel or you need to manually consider and write header name for the first row's Header.

 

ashok_rajm
Contributor III
Contributor III

Hi,
May be you can load the first row from Excel, and use Alias to rename the fields in Load Script, and this will be one time activity:

LOAD F1 as Value,
[Risk ID],
[Risk Summary],
Priority,
Impact as [Impact Value],
F6 as [Impact Color],
Probability as [Probability Value] ,
H as [Probability Color]
FROM

Hope this helps.