Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
emanuel_oxi
Contributor III
Contributor III

Read data from Excel file in Load Script

Hey folks,

I'm pretty new with Qlik.

Task:

     I want to read in the following Excel row by row.

     Because the values of each row belong together.

     Excel_File.png

Problem:

     Qlik conclude my data per column.

     In column C (Datei / Tabelle) Qlik is not showing 7 times 'UBPERP', instead there is only one time 'UBPERP'.

     It seams like Qlik is loading each column distinct.

    

My Code:

     Here is my code including the debug information in the comments.

     Code.png

Question:

     How can I prevent Qlik from loading distinct?

     Or is there any other approach to do this?

1 Solution

Accepted Solutions
Not applicable

to learn more about data storage in Qlikview, look into below ppt file.

Qlikview Data Storage

-Ashok

View solution in original post

3 Replies
Not applicable

Hi Emanuel,

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".

-Ashok

Not applicable

to learn more about data storage in Qlikview, look into below ppt file.

Qlikview Data Storage

-Ashok

View solution in original post

emanuel_oxi
Contributor III
Contributor III
Author

Hey Ashok,

thanks for your quick response.

So Qlik is working as I already assumed.

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.

Do you have any ideas how to do this?

-Emanuel