Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

rupesh632
Contributor

load single table in qlik sense

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

3 Replies
YoussefBelloum
Esteemed Contributor

Re: load single table in qlik sense

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

rupesh632
Contributor

Re: load single table in qlik sense

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
Honored Contributor III

Re: load single table in qlik sense

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.

Community Browser