topic Re: Field not found when loading from QVD in QlikView

Field not found when loading from QVD

Thu, 13 Nov 2014 09:20:25 GMT

Hi,

We have scripts in multiple tabs, in one of the tab we have stored few fields into a QVD. When I tried to load fields from that QVD in next tab, "Field not found is being thrown". LOAD * from QVD shows the fields in upper cases but the table which is being stored into the QVD does have fields in mixed cases. How to ignore fields without getting converted to upper cases in QVDs?

eg. TAB:

Load *

Select a,Ba,CC from table1;

Store TAB into a.qvd;

load a

Select a from a.qvd(qvd);

Error: Field not found: a is missing in QVD

Workaround: Convert field names into upper case works.

Load a

Select A from a.qvd (qvd);

So how can I store fields without getting changed into a QVD?

Thanks,

Nirmal.

Re: Field not found when loading from QVD

senpradip007 — Thu, 13 Nov 2014 09:24:42 GMT

Nirmal Azhagarselvam wrote:

Hi,

We have scripts in multiple tabs, in one of the tab we have stored few fields into a QVD. When I tried to load fields from that QVD in next tab, "Field not found is being thrown". LOAD * from QVD shows the fields in upper cases but the table which is being stored into the QVD does have fields in mixed cases. How to ignore fields without getting converted to upper cases in QVDs?

eg. TAB:

Load *

Select a,Ba,CC from table1;

Store TAB into a.qvd;

load a

Select a from a.qvd(qvd);

Error: Field not found: a is missing in QVD

Workaround: Convert field names into upper case works.

Load a

Select A from a.qvd (qvd);

So how can I store fields without getting changed into a QVD?

Thanks,

Nirmal.

Ty like:

load a

from a.qvd(qvd);

Re: Field not found when loading from QVD

Thu, 13 Nov 2014 09:32:09 GMT

Hi,

Thanks for your response.

Sorry that was a typo. I have used Load a from a.qvd (qvd); only.

Thanks

Re: Field not found when loading from QVD

ashfaq_haseeb — Thu, 13 Nov 2014 09:42:29 GMT

Hi,

Try like this

load a

from "a".qvd(qvd);

load a

from .qvd(qvd);

Let me know if that worked.

Regards

ASHFAQ

Re: Field not found when loading from QVD

Thu, 13 Nov 2014 09:58:46 GMT

Hi,

try this

eg. TAB:

Load *;

SQL Select a,Ba,CC from table1;

Store TAB into a.qvd(qvd);

Tab2:

load a from a.qvd(qvd);

Select a from a.qvd(qvd);----> this is not correct while loading from qvd we use Load statement only not SQL Select staement

Error: Field not found: a is missing in QVD

if you want upper case:

Load upper(a) as A;

Load a from a.qvd(qvd);

Re: Field not found when loading from QVD

Thu, 13 Nov 2014 10:13:50 GMT

Hi,

I have tried it but different error is thrown saying the file (QVD) itself not found.

Re: Field not found when loading from QVD

ashfaq_haseeb — Thu, 13 Nov 2014 10:16:43 GMT

Ok it may happen due to sharing violations.

Do one thing Close all qvw files you opened

open new qvw file and try the above suggestions.

Let me know it that worked.

Regards

ASHFAQ

Re: Field not found when loading from QVD

Thu, 13 Nov 2014 10:18:37 GMT

Hi,

That is how I have done, sorry I posted wrong statement for load from QVD.

Load a from a.qvd (qvd); not works but Load A from a.qvd works. I could have applied upper() or changed the column name directly but there are numerous columns to change. Hope there should be some work around to store fields in normal case into QVD and load should work fine without any conversion.

Thanks

Re: Field not found when loading from QVD

Thu, 13 Nov 2014 10:27:55 GMT

Hi,

It worked when after closing all open QVW and tried to load from new qvw.

I did not even use [] or "". How to use it in existing QVW now?

Thanks

Re: Field not found when loading from QVD

ashfaq_haseeb — Thu, 13 Nov 2014 10:41:48 GMT

Hi,

Same concept

You need to make sure that this a.qvw should not be open in multiple files.

Or it it may cause sharing violation.

Close all qvw files and only open the one that you want this to work.

Regards

ASHFAQ