.txt Load

tomcatxx — Wed, 25 Nov 2020 16:16:04 GMT

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.


020118	Tom	Night	121215
	Test Value 1	Test Value 2	Test Value 3
Nr		N	mm
1	x	x	x
2	x	x	x
3	x	x	x
4	x	x	x
5	x	x	x
6	x	x	x

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

Nr	Test Value 1	Test Value 2	Test Value 3	Date	Worktime	Inspector	ProductNr.
1	x	x	x	020118	Night	Tom	121215
2	x	x	x	020118	Night	Tom	121215
3	x	x	x	020118	Night	Tom	121215
4	x	x	x	020118	Night	Tom	121215
5	x	x	x	020118	Night	Tom	121215
6	x	x	x	020118	Night	Tom	121215
1	x	x	x	020118	Morning	Marco	221426
2	x	x	x	020118	Morning	Marco	221426
3	x	x	x	020118	Morning	Marco	221426
4	x	x	x	020118	Morning	Marco	221426
5	x	x	x	020118	Morning	Marco	221426
6	x	x	x	020118	Morning	Marco	221426
1	x	x	x	020118	Afternoon	Marco	221426
.	..	..	..	..	..	..	..
.	..	..	..	..	..	..	..

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

topic .txt Load in QlikView

.txt Load