topic Re: Table alias in QlikView

Table alias

Wed, 25 Mar 2015 12:59:57 GMT

Hi Team,

I have an excel file containing unusual header names like F1, F2, F3 etc.

I want to change it in the form SubjectName_Externals, SubjectName_Internals and SubjectName_Practicals.

but the problem that I am facing is

Subject name is either of 2 word or more as shown below

Subject1 = 'Embedded System';

Subject2 = 'Imformation Security Management';

Kindly help me with a solution to resolve this issue.

I have also attached qvw file.

Regards

Priyanka

Re: Table alias

JonnyPoole — Wed, 25 Mar 2015 13:07:11 GMT

add square brackets in the variable values

change :

Let Subject1 = 'Embedded System';

Let Subject2 = 'Imformation Security Management';

Let Subject4 = 'Ethical hacking';

to:

Let Subject1 = '[Embedded System]';

Let Subject2 = '[Imformation Security Management]';

Let Subject4 = '[Ethical hacking]';

Re: Table alias

Wed, 25 Mar 2015 13:13:42 GMT

Hi Jonathan,

Thanks for you reply.

I tried to implement it and I got syntax error.

Regards,

Priyanka

Re: Table alias

prieper — Wed, 25 Mar 2015 13:27:42 GMT

You need to put square brackets into the script, not the variables:

Directory;

LOAD [Student Name] as Student_Name,

[Paper-I] as [$(Subject1)_$(Ext)],

....

Peter

Re: Table alias

Wed, 25 Mar 2015 13:35:40 GMT

Thanks Peter

Re: Table alias

Gabriel — Wed, 25 Mar 2015 13:37:47 GMT

Hi,

Try this

Let Subject1 = chr(91) & 'Embedded System' & chr(93);
Let Subject2 = chr(91) & 'Imformation Security Management' & chr(93);
Let Subject3 = chr(91) & 'Virtualization' & chr(93);
Let Subject4 =chr(91) & 'Ethical hacking' & chr(93);

Re: Table alias

JonnyPoole — Wed, 25 Mar 2015 13:38:58 GMT

Hi - yes sorry. because you are using 2 variables the square brackets need to come at the beginning and end of the full string. Something like this:

Let Ext = 'External]';

Let Int = 'Internals]';

Let Prac = 'Practical]';

Let Subject1 = '[Embedded System';

Let Subject2 = '[Imformation Security Management';

Let Subject3 = '[Virtualization';

Let Subject4 = '[Ethical hacking';

then this:

[Paper-I] as

$(Subject1)_$(Ext),

will evaluate to

[Paper-I] as

[Embedded System_External];

Or you can try the valid alternative mentioned by PR too.