topic Load Script - SQL Ordinal Position rather than SQL Column Name in QlikView https://community.qlik.com/t5/QlikView/Load-Script-SQL-Ordinal-Position-rather-than-SQL-Column-Name/m-p/359890#M1175308 <HTML><HEAD></HEAD><BODY><P>I'm trying to minimize the number of reports that I have to manage by giving clients the exact same report and just wiring the report to each client db (one glove fits all).&nbsp; However, clients have the option of defining a few SQL column names, which may or may not be different for each client.&nbsp; For example, one client may want to name ColumnA "Manager" another client may want to name ColumnA "Director", while another may want to name ColumnA "Supervisor".&nbsp; The position of the ColumnA will always stay the same.&nbsp; With that, is there a way in QV to pull in the ordinal position of a column from SQL?&nbsp; I'm trying make this report as dynamic as possible. </P></BODY></HTML> Thu, 19 Apr 2012 16:05:21 GMT 2012-04-19T16:05:21Z Load Script - SQL Ordinal Position rather than SQL Column Name https://community.qlik.com/t5/QlikView/Load-Script-SQL-Ordinal-Position-rather-than-SQL-Column-Name/m-p/359890#M1175308 <HTML><HEAD></HEAD><BODY><P>I'm trying to minimize the number of reports that I have to manage by giving clients the exact same report and just wiring the report to each client db (one glove fits all).&nbsp; However, clients have the option of defining a few SQL column names, which may or may not be different for each client.&nbsp; For example, one client may want to name ColumnA "Manager" another client may want to name ColumnA "Director", while another may want to name ColumnA "Supervisor".&nbsp; The position of the ColumnA will always stay the same.&nbsp; With that, is there a way in QV to pull in the ordinal position of a column from SQL?&nbsp; I'm trying make this report as dynamic as possible. </P></BODY></HTML> Thu, 19 Apr 2012 16:05:21 GMT https://community.qlik.com/t5/QlikView/Load-Script-SQL-Ordinal-Position-rather-than-SQL-Column-Name/m-p/359890#M1175308 2012-04-19T16:05:21Z