Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For example,
Rawdata:
LOAD * INLINE [
Institution, Distributor,Sales
A101,B101,500
A101,B102,700
A102,B101,600
B101,C102,350
B101,D103,200
A103,C102,600
......
];
table A in the QV,
I want to create a column "Memo" to let users input their notice information.
Because the "Memo" is not set on unique row in Rawdata, I think inputfield function is unuseful to do it.
And I want to create an other table in the script like following:
Memo:
Replace only
LOAD Institution,
Memo
FROM
(txt, codepage is 936, embedded labels, delimiter is ',', no quotes);
then the running process like:
1) user input the Memo in input-box
2) write to TXT file by Macro
3) run Partial Reload by Macro to read the Memo
Is it realizable?