topic Re: Capitalize column names in table in QlikView

Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 09:55:32 GMT

i have 10-11 tables and in each table i have columns .. also expression now also did rename expression with label like this

"Salary" now i want all column names in capitalize like SALARY so this is difficult for me to look on each table and capitalize each column so is this possible to capitalize column name globally ?

Re: Capitalize column names in table

pradosh_thakur — Thu, 21 Feb 2019 10:06:05 GMT

use the below script from the thread may be

https://community.qlik.com/t5/New-to-QlikView/convert-column-name-to-upper-case/td-p/882695

Re: Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 10:30:22 GMT

will you please post solution here.. and secondly i dont want to do in script .. is there alternate way

Re: Capitalize column names in table

pradosh_thakur — Thu, 21 Feb 2019 10:37:05 GMT

how can you capitalize the column names in UI and not in script?

Please modify the script. It is copied from the script in the post above mentioned

Directory;

FILE:

load * inline [

file, table

b.xlsx, B_TABLE

a.xlsx, A_TABLE

c.xlsx,C_TABLE

];

// loop and read excel files

for file=0 to NoOfRows('FILE')-1;

let filename=Peek('file', $(file), 'FILE');

let tablename=Peek('table', $(file), 'FILE');

$(tablename):

load * from $(filename)

(ooxml, embedded labels, table is Sheet1);

// loop on table fields to build the "rename as" for every field

let s = '';

for field=1 to NoOfFields('$(tablename)');

let s = '$(s)'

& if(len('$(s)')>0, ',' & chr(10), '')

& '[' & FieldName($(field), '$(tablename)') & ']'

& ' as ' & '[' & upper(FieldName($(field), '$(tablename)')) & '] ';

NEXT field;

// read table using the "rename as"

rename table $(tablename) to TMP;

$(tablename):

NoConcatenate load

$(s)

Resident TMP;

DROP Table TMP;

NEXT file;

Re: Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 11:04:43 GMT

so i have 3 + scripts so on every scripts i paste this ?

/ loop on table fields to build the "rename as" for every field

let s = '';

for field=1 to NoOfFields('$(tablename)');

let s = '$(s)'

& if(len('$(s)')>0, ',' & chr(10), '')

& '[' & FieldName($(field), '$(tablename)') & ']'

& ' as ' & '[' & upper(FieldName($(field), '$(tablename)')) & '] ';

NEXT field;

Re: Capitalize column names in table

pradosh_thakur — Thu, 21 Feb 2019 11:07:11 GMT

what do you mean by 3 scripts? In every app you need to use this once as per my understanding. You can see your scripts better so please take a call on that as per your requirement.

PS. Please take back up before trying anything

Re: Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 11:25:52 GMT

means i have a multiple scripts in qlikview so want to ask in each scripts i paste or this or

Re: Capitalize column names in table

pradosh_thakur — Thu, 21 Feb 2019 11:38:02 GMT

you have to paste this one time per app and the for loop will take care of everyhting

Re: Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 11:43:50 GMT

ok in the loop there is tablename so here i write my tablename or i just paste this with "tablename" text?

Re: Capitalize column names in table

capriconuser — Thu, 21 Feb 2019 11:51:25 GMT

and this shows an error when i paste this

let s = '';

for field=1 to NoOfFields('$(tableabc)');

let s = '$(s)'

& if(len('$(s)')>0, ',' & chr(10), '')

& '[' & FieldName($(field), '$(tableabc)') & ']'

& ' as ' & '[' & upper(FieldName($(field), '$(tableabc)')) & '] ';

NEXT field;