Variable issue - Field appearing in source table view but not internal

[#1]

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

[#2 · Accepted solution]

I have now smashed this.

[#3]

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