Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
UNQUALIFY *;
HIST:
NoConcatenate
LOAD *
Resident TMP_HIST;
trace ====== Store CSV ======;
store HIST into \\DATA\Raw_Data\HIST.txt (txt);
Try this:
UNQUALIFY *;
HIST:
NoConcatenate
LOAD *
Resident TMP_HIST;
trace ====== Store CSV ======;
store HIST into \\DATA\Raw_Data\HIST.txt (txt);
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.
Use of NoConcatenate will solve your problem before HIST:
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);
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.
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.
Perfect, thank you all for your help