Qlikview by default it stores distinct data only. when you open list box of column C (Datei / Tabelle), it shows only distinct values. but internally all records are associated with it. If you want to see data exactly as it is in excel, add all coloumns into "Table box".
I know how to see all data (e.g. usage of a table box).
But I need these data in the load script.
Because I have to know the value of column 'D' with the value of column 'C'.
E.g. in line 7 => table 'UBPERP' has a field with the name: 'UPYPDP'.
If I know this I can prepare a SQL-Request which selects UPYPDP from UBPERP and save the response in a QVD.
In short: This Excel file is an abstract version of my data model. Thus I want to parse the Excel, request the data from the SQL-Database and save them in a QVD-File. The current problem is that I have no reference between the column in the load script.