Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

.txt Load

Hi there, I have a problem. Can u help me? Thank you.

There are many .txt documents. They are test data of products for 1 year. Everyday we have 3 tables for worktime 'Morning', 'Afternoon' and 'Night'. I want to load them in one Table.

The first .txt looks like so, and other .txt are in same form. Only vaule is different. N and mm are data units. We dont need them anymore in new Table.

020118Tom              Night121215
Test Value 1Test Value 2Test Value 3
NrNmm
1xxx
2xxx
3xxx
4xxx
5xxx
6xxx

What I want looks like so. All data for 1 years will be there.

NrTest Value 1Test Value 2Test Value 3DateWorktimeInspectorProductNr.
1 xxx020118NightTom121215
2xxx020118NightTom121215
3xxx020118NightTom121215
4xxx020118NightTom121215
5xxx020118NightTom121215
6xxx020118NightTom121215
1xxx020118MorningMarco221426
2xxx020118MorningMarco221426
3xxx020118MorningMarco221426
4xxx020118MorningMarco221426
5xxx020118MorningMarco221426
6xxx020118MorningMarco221426
1xxx020118AfternoonMarco221426
...............
...............

I think it's about 2 points, crosstable Load and SUB ScanFolder(Root) .

0 Replies