23 Replies Latest reply: Sep 26, 2014 5:32 AM by Ian Porter RSS

    Problem with fields using resident

    Ian Porter

      Hi, Sorry, I have lots of SQL experience but new to Qlik.

      I have a script that loads from an odbc connection and I want to then use it in a load using resident.

      Even the simple one below gives a script error as

      Field not found - <fwk_num>

      trade_data: 

      LOAD

      fwk_num

      RESIDENT trade_trans

       

      What am I doing wrong?

      I tried the unqualify command that I found when looking up these type of errors but it too didnt work.

       

      I am using the free trial version at the minute as my company is still in the process of buying licences.

      Is it a restriction of the trial version?

       

      Script after the ODBC connect string is shown below.

      Thanks for reading.

       

      trade_trans:

      Select

      fwk_num

      FROM

        dw.CALENDAR;

       

      trade_data: 

      LOAD

      fwk_num

      RESIDENT trade_trans;

       

      store trade_data into 201422_trade.qvd;