It sounds like you'll want to do a generic load followed by a loop to combine the generic tables back into a single table. See the attached example of how to do that. Here's the script.
LOAD * INLINE [
LEFT JOIN ([Table])
,if("Invoice No."=previous("Invoice No."),peek("Product Number")+1,1) as "Product Number"
ORDER BY "Invoice No."
,'Product ' & "Product Number" as "Product Number"
LOAD DISTINCT "Invoice No." // add other key fields to this list
FOR I = nooftables() TO 0 STEP -1
LET vTable = tablename(I);
IF wildmatch('$(vTable)','Generic.*') THEN
OUTER JOIN ([Final])
DROP TABLE [$(vTable)];
DROP TABLE [Table];
testGenericOneTable.qvw 119.0 K
If you simply want to display the data in QlikView with columns customer, order, amount of kind1, amount of kind2 etc. you could load the original table unaltered, and then create a pivot table in QlikView.
Let's say you had the following data:
Just load it as it is into QlikView. Then create a pivot table with dimensions Customer, Order and Kind, and the expression sum(Amount).
Then drag the Kind column to the top, which would give you:
Is that what you were after?