change table header for different columns

[onkarkulkarni]

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

[rajkumart]

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]

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.