topic Re: Variable issue - Field appearing in source table view but not internal in QlikView

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

Thu, 14 Feb 2013 12:14:02 GMT

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

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

Thu, 14 Feb 2013 12:24:59 GMT

I have now smashed this.

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

Thu, 14 Feb 2013 12:41:40 GMT

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