Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store a table without using Qualify

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

UNQUALIFY *;
HIST:

NoConcatenate
LOAD *
Resident TMP_HIST;

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

View solution in original post

7 Replies
sunny_talwar

Try this:

UNQUALIFY *;
HIST:

NoConcatenate
LOAD *
Resident TMP_HIST;

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

agustinbobba
Partner - Creator
Partner - Creator

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.

Anonymous
Not applicable
Author

Use of NoConcatenate will solve your problem before HIST:

swuehl
MVP
MVP

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

sunny_talwar

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.

swuehl
MVP
MVP

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.

Not applicable
Author

Perfect, thank you all for your help