topic Re: Fields Names Having Spaces in QlikView

Fields Names Having Spaces

Anonymous — Thu, 30 May 2013 19:28:41 GMT

I make use of Qulaify, for exapmle:

Qualify *;

Table1:

Load [Cust ID],

[Field B]

From Tab1;

Unqualify *;

Store Table1 into Temp:\Table1.qvd

Then, I make use of this QVD in:

Customer:

Load Name,

From Cust;

Left Join (Customer)

Load Table1.Cust ID

From Temp:\Table1.qvd

I get error for field not found. I know I can rename Cust ID to ID before storing but I wanted to keep it as it is.

Also, I tried enclosing with [] as [Table1.Cust ID] but doesn't work either.

Re: Fields Names Having Spaces

vivientexier — Thu, 30 May 2013 19:45:32 GMT

Put your "Qualify *;" before the name of the table.

Re: Fields Names Having Spaces

Anonymous — Thu, 30 May 2013 19:49:48 GMT

I'm putting it before table name actually (and havng the issue), in this example did not do it properly. Just corrected it above.

Re: Fields Names Having Spaces

Miguel_Angel_Baeyens — Thu, 30 May 2013 20:06:04 GMT

Hi,

All field names with spaces must be wrapped by square brackets or double quotes. In your first table, the "Cust ID" is not using them, and that might be the issue:

Qualify *;
Table1:
Load [Cust ID],
        Field B
From Tab1;

Hope that helps.

Miguel

Re: Fields Names Having Spaces

Anonymous — Thu, 30 May 2013 20:08:56 GMT

Sorry, about that.

Actually, they are wrapped in saqure brackets ([]) under Table 1.

Problem occurs when I call them from another file.

Re: Fields Names Having Spaces

Miguel_Angel_Baeyens — Thu, 30 May 2013 21:44:55 GMT

Hi,

Ok, it's in a QVD, so open it using the "QlikView File" button in the script editor window.

Hope that helps.

Miguel

Re: Fields Names Having Spaces

vivientexier — Fri, 31 May 2013 05:04:30 GMT

Please, show exactly the script you are using.

Re: Fields Names Having Spaces

er_mohit — Fri, 31 May 2013 06:00:44 GMT

hii i tried your code with inline here you minor mistake in last syntax when you fetch the table from qvd the syntax is E:\Tab.qvd

(qvd);

see my code

Qualify *;

Tab1:

LOAD * INLINE [

Cust ID, Field B

10, 20

3, 54

2, 4

5, 45

5, 3

];

Unqualify *;

Store Tab1 into E:\Tab.qvd;

drop Table Tab1;

Customer:

LOAD * INLINE [

Name, ID

1, 4

2, 4

3, 4

3e3, 4

44, 4

];

Left Join(Customer)

LOAD [Tab1.Cust ID],

[Tab1.Field B]

FROM

E:\Tab.qvd

(qvd);

hope it helps