Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am confused as to why a field is not appearing in my internal table viewer.
I am loading in the max date from a QVD which I want to assign to a variable as part of an incremental load script. However when I run the code the maxdate field appears in the source table viewer, can be used in table boxes etc but does not appear on the internal table viewer and when I try to use the variable it returns a blank field.
Here is the script:
Max:
LOAD max(edate) as MaxDate FROM [...\...\...\...\EmailCapture.QVD](qvd);
Let vLastExecDate = 'MaxDate';
Can anyone help to explain why this might be happening?
Thanks
I have now smashed this.
I have now smashed this.
I am confused..
Does this mean that you have now worked this out, requiring no further assistance.
ps. I do not know the answer to your question
many thanks