But this is actually a cartesian product that does not exhibit its usual data explosion because your example is very limited. Cartesian Products must be tightly controlled, or they'll produce unwanted effects.
You're sure that you don't have a common field in those two tables for the JOIN to match rows?
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
It's a product test record. Value1 is date, Value2 is Tester, Value3 is worktime and Value4 is productID. kg, N and mm are units(I dont need load units). I have more than 1000 txt documents like that .
One example is:
20.06.2018 Tom Night 1001
Test 1 Test 2 Test 3
Nr kg 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
I think it contains 2 parts.
So I loaded this txt document in 2 tables.
1.txt
21.06.2018 Tom Night 1001
2.txt
Nr Test 1 Test 2 Test 3
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 is
Nr Test 1 Test 2 Test 3 Date Tester Worktime ProductID
Product ID is present in every original text file. You could translate the current text file split code into a FOR EACH loop that scans all text files and for every text file
parses the first line into 4 variables (vDate, vTester, vWorktime and vProductID)
LOADs all other lines (skip the first one) as a fixed format table and Autoconcatenate the fields together with the four variables into the target table. This LOAD will skip any row for which Field1 = 'Nr' (the units line)
That way, you can do all the work in one big sweep.
