Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pawel_manu
Not applicable

Direct Discovery

Hello Everyone,

My questions goes to new functionality of Direct Discovery (QV 11.2).

  • Is it possible to load more then one table like this?
  • Is it possible to make WHERE limitations to source data while using DIRECT?

I tried like this - and third statement failed (it fails even when I remove WHERE clause). It loads only tableA.

ODBC CONNECT TO ODBC_Teradata (XUserId is zyzyryxy, XPassword is blablablasimple);

DIRECT SELECT column_a, column_b IMPLICIT column_c

FROM schema.tableA;

DIRECT SELECT column_a,column_d IMPLICIT column_e

FROM schema.tableB

WHERE date_of_day > date - 1;

Thanks in advance for info.

Best regards,

Paweł

2 Replies
Miguel_Angel_Baeyens
Not applicable

Re: Direct Discovery

Hi Paweł,

As far as I know, only one direct discovery table is allowed per load script / QVW file for the time being, so it makes sense that the second throws an error. You should use two different QVW applications if you want to use those two queries.

Hope that helps.

Miguel

Not applicable

Re: Direct Discovery

Use view at db side. Create common structure and provide data source indicator on result data set. Passing parameters value of particular table get data direct from db and draw what you want.