load single table in qlik sense

[Anonymous]

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);

[YoussefBelloum]

What do you want to do ? it is not clear on your message

[Anonymous]

it is data load script in qlik sense

these are the two table which suppose to be load but i just wanted to load single table without affecting the users that means message should not got to the user in the front report saying that please wait...data is being loaded...it should happend in the back end via automation

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);

[shraddha_g]

If app is published in stream and you have scheduled task for execution then this message is not shown on front end.

If app is in my work then only this message is displayed.