Fields Names Having Spaces

[Anonymous]

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,

         ID

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.

[vivientexier]

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

[Anonymous]

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

[Miguel_Angel_Baeyens]

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

[Anonymous]

Sorry, about that.

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

Problem occurs when I call them from another file.

[Miguel_Angel_Baeyens]

Hi,

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

Hope that helps.

Miguel

[vivientexier]

Please, show exactly the script you are using.

[er_mohit · Accepted solution]

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