3 Replies Latest reply: Nov 15, 2017 2:05 AM by Shraddha Gajare RSS

    load single table in qlik sense

    Rupesh Shelar

      Hi Expert,

      How to load only single table in data load editor without affecting the app for an example it should not affect the users saying please wait data is being loaded message..is there any way we can be automated this

      Please find my data load editor script

       

      SET ThousandSep=',';

      SET DecimalSep='.';

      SET MoneyThousandSep=',';

      SET MoneyDecimalSep='.';

      SET MoneyFormat='$#,##0.00;-$#,##0.00';

      SET TimeFormat='h:mm:ss TT';

      SET DateFormat='M/D/YYYY';

      SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

      SET FirstWeekDay=6;

      SET BrokenWeeks=1;

      SET ReferenceDay=0;

      SET FirstMonthOfYear=1;

      SET CollationLocale='en-US';

      SET CreateSearchIndexOnReload=1;

      SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

      SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

      SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

      SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

       

       

       

       

      // LOAD

      //     record_no,

      //     pac,

      //     x,

      //     y

      // FROM [lib://Data/TRENDLINE_TEST.xlsx]

      // (ooxml, embedded labels, table is Sheet1);

       

       

       

       

      LOAD

          record_no,

          pac,

          x,

          y,

          Outlier,

          x1,

          y1

      FROM [lib://Data/Trendline_capex1411.xlsx]

      (ooxml, embedded labels, table is Sheet1);