Field not found when loading from QVD

[#1]

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.

[senpradip007]

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);

[#3]

Hi,

Thanks for your response.

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

Thanks

[ashfaq_haseeb]

Hi,

Try like this

load a

from  "a".qvd(qvd);

or

load a

from  .qvd(qvd);

Let me know if that worked.

Regards

ASHFAQ

[#5]

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);

[#6]

Hi,

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

[ashfaq_haseeb]

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

[#8]

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

[#9]

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

[ashfaq_haseeb]

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