topic Store fields leads to Unknown error in QlikView

Store fields leads to Unknown error

agaetisproject — Tue, 07 Jun 2016 13:26:40 GMT

I try to export a sub-set of a table from my load script by using the Store function.

It works very well as soon as the number of fields is limited. More precisely, when I export less than 13 fields.

As soon as I want to list more fields, I get an export error.

Store

Field01,

Field02,

...

Field14

From TableName into filename.txt;

Have you ever noticed that on your end?

Corollary, is it possible to extract all fields using * and specify the fields I do not want to appear in the extract.

Thanks in advance for you help!

Regards,

Re: Store fields leads to Unknown error

sunny_talwar — Tue, 07 Jun 2016 14:11:21 GMT

Have you tried this:

Store TableName into filename.txt;

Re: Store fields leads to Unknown error

agaetisproject — Tue, 07 Jun 2016 20:03:16 GMT

This will export all fields Sunny. I only want to export a subset of the fields.

My issue is that the syntax is crashing if the number of fields I specify is above 13.

That should not the the case so I suspect a bug there.

Re: Store fields leads to Unknown error

sunny_talwar — Tue, 07 Jun 2016 20:10:22 GMT

What if you create a resident with only those fields which are needed and then store it?

NewTable:

LOAD Field1,

Field2,

...

Resident TableAbove;

STORE NewTable into......

Re: Store fields leads to Unknown error

MarcoWedel — Tue, 07 Jun 2016 22:29:32 GMT

can you provide a sample application to test with?

thanks

regards

Marco

Re: Store fields leads to Unknown error

marcus_sommer — Wed, 08 Jun 2016 11:03:06 GMT

For me it worked fine with:

load * inline [

F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F14 F15

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

] (txt, delimiter is '\t');

store F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15 from t into testtest.txt (txt);

therefore I think that your problem is different to the number of fields - maybe it's missing the fileformat (bolded above) or something within the data (any kind of special chars like an eof which breaks the process) or something similar. Which release do you use (mine is QV 11 SR12)?

- Marcus