topic Re: load single table in qlik sense in Integration, Extension & APIs

load single table in qlik sense

Anonymous — Tue, 14 Nov 2017 16:17:39 GMT

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,

Outlier,

x1,

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

(ooxml, embedded labels, table is Sheet1);

Re: load single table in qlik sense

YoussefBelloum — Tue, 14 Nov 2017 16:25:30 GMT

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

Re: load single table in qlik sense

Anonymous — Tue, 14 Nov 2017 16:46:11 GMT

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,

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

(ooxml, embedded labels, table is Sheet1);

LOAD

record_no,

pac,

Outlier,

x1,

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

(ooxml, embedded labels, table is Sheet1);

Re: load single table in qlik sense

shraddha_g — Wed, 15 Nov 2017 07:05:00 GMT

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.