Databases Reference
In-Depth Information
The generated script looks as follows:
LOAD Date,
[Plant #],
[Product Line ID],
[Estimated Production]
FROM
[Production Planning - Legacy.txt]
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq,
filters(
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total'))),
Unwrap(Col, Pos(Top, 5)),
Remove(Row, RowCnd(Compound,
RowCnd(CellValue, 1, StrCnd(contain, 'Date')),
RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0))
)),
Replace(1, top, StrCnd(null))
));
After reloading the script, we can open the Table Viewer window and see that we
have a nicely formatted table with the Production Planning data:
As the code was generated and pasted into the script editor, every time the TXT
report is updated we just need to re-run the script to update the data in the QlikView
document, without having to go through of all the steps over again.
