topic Re: Error with Inline Table in QlikView

Error with Inline Table

swati_rastogi27 — Fri, 03 Jun 2016 14:56:34 GMT

Hi ,

I am using below query :

TMP_TABLE_MAX_DATE:

LOAD MAX(DATA_DATE) AS MAX_DATE RESIDENT TMP_TABLE;

Let vMax_DATA_DATE = date(peek('MAX_DATE',0,'TMP_TABLE_MAX_DATE'),'DD-MMM-YYYY');

Drop table TMP_TABLE_MAX_DATE;

TEST_TABLE:

LOAD date(Date#('$(vMax_DATA_DATE)','DD-MMM-YYYY')) AS MAX_TEST_DATE

INLINE[

MAX_TEST_DATE];

Here I am getting below error :

Syntax error, missing/misplaced FROM:

TEST_TABLE:

LOAD date(Date#('','DD-MMM-YYYY')) AS MAX_TEST_DATE

INLINE[

MAX_TEST_DATE]

TEST_TABLE:

LOAD date(Date#('','DD-MMM-YYYY')) AS MAX_TEST_DATE

INLINE[

MAX_TEST_DATE]

Can someone help?

Re: Error with Inline Table

sunny_talwar — Fri, 03 Jun 2016 14:59:56 GMT

May be try this:

TMP_TABLE_MAX_DATE:

LOAD MAX(DATA_DATE) AS MAX_DATE

RESIDENT TMP_TABLE;

LET vMax_DATA_DATE = Peek('MAX_DATE', 0, 'TMP_TABLE_MAX_DATE');

DROP Table TMP_TABLE_MAX_DATE;

TEST_TABLE:

LOAD Date($(vMax_DATA_DATE)) as MAX_TEST_DATE

AutoGenerate 1;