topic Re: Store a table without using Qualify in QlikView

Store a table without using Qualify

Thu, 07 Apr 2016 12:15:08 GMT

Hi, hope you clever guys can help me here. I'm trying to store a table in my script as a txt file, which I can do ok.

The problem I have is that I want to do it without putting [TABLE NAME.] in front of the field names. ie I don't want to use Qualify.

I want to do the below, which tells me that the HIST table doesn't exist when I run my script, if I put QUALIFY *; instead of UNQUALIFY *; it works but puts HIST. in front of my field names.

UNQUALIFY *;
HIST:
LOAD *
Resident TMP_HIST;

trace ====== Store CSV ======;
store HIST into \\DATA\Raw_Data\HIST.txt (txt);

Thank you

Re: Store a table without using Qualify

sunny_talwar — Thu, 07 Apr 2016 13:15:45 GMT

Try this:

UNQUALIFY *;
HIST:

NoConcatenate
LOAD *
Resident TMP_HIST;

trace ====== Store CSV ======;
store HIST into \\DATA\Raw_Data\HIST.txt (txt);

Re: Store a table without using Qualify

agustinbobba — Thu, 07 Apr 2016 13:19:59 GMT

Hi!,

Use NoConcatenate for the load of Hist, the problem it seem to be that your tables has the same structure so QV concatenate by default.

Best regards,

Agustin.

Re: Store a table without using Qualify

Anonymous — Thu, 07 Apr 2016 13:59:57 GMT

Use of NoConcatenate will solve your problem before HIST:

Re: Store a table without using Qualify

swuehl — Thu, 07 Apr 2016 14:23:23 GMT

With this (maybe simplified) sample code, I believe there is no need for another resident load:

UNQUALIFY *;
HIST:

NoConcatenate
LOAD *
Resident TMP_HIST;

trace ====== Store CSV ======;
store TMP_HIST into \\DATA\Raw_Data\HIST.txt (txt);

Re: Store a table without using Qualify

sunny_talwar — Thu, 07 Apr 2016 14:26:10 GMT

I guess the question is, how would he UNQUALIFY (Remove TMP_HIST from next to his field names). I think neither of the two options is going to do that, right?

OP will manually have to do this or do Unqualify *; before TMP_HIST and then save it.

Re: Store a table without using Qualify

swuehl — Thu, 07 Apr 2016 14:30:29 GMT

Good point.

I assumed he doesn't use Qualify * for the first table, since then he would have seen something like

HIST.TMP_HIST.FIELDNAME

But maybe that assumption is just totally wrong.

Re: Store a table without using Qualify

Fri, 08 Apr 2016 08:44:25 GMT

Perfect, thank you all for your help