reload file from excel for end users

capriconuser — Fri, 02 Mar 2018 05:28:04 GMT

I have script like this

INPUTFIELD Amount1,Amount2;

Fact:

LOAD * INLINE [

Group,Sales,

A,345

B,12

C,45

D,56

E,79

F,12

g,12

h,12

h,4

];

Fact1:

LOAD

*,Sales as Amount1,'' as Amount2,

RecNo() as ID

Resident Fact;

Store Fact Into Fact.qvx;

and there is reload button for end users.. now i want when user click on send to excel on table then when they enter new record and click on reload then want that updated data in table .. how i do this

any help please

Re: reload file from excel for end users

Qrishna — Sat, 03 Mar 2018 10:08:21 GMT

try:

INPUTFIELD Amount1,Amount2;

Fact:

LOAD

RecNo() as ID,

Sales as Amount1,

'' as Amount2,;