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,
| Institution | Total Sales | Memo |
|---|
| A101 | 1200 | [user input]:it's high |
| A102 | 600 | |
| A103 | 600 | |
| B101 | 550 | [user input]:it's lower,please notice |
| ... | ... | ... |
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?
