Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
James_Smith
Contributor
Contributor

Unable to create Straight Table using macro

Hello,

I would like to create a Straight Table using data from Excel.

However, when I load the data with the macro, it is always loaded as separate listboxes and not a table.

Why does this happen? I've google everywhere, but cannot find anything similar.

 

 

LOAD A, 
     B, 
     C, 
     D, 
     E, 
     F, 
     G, 
     H, 
     I, 
     J, 
     K, 
     L, 
     M
FROM
[C:\*.xlsx]
(ooxml, no labels, table is [Equipment list]);

 

 

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

There is no macro-code else just a normal script to load from an Excel. If this loaded you will have a table within the data-model which you could display within the UI in a table-chart.

View solution in original post

1 Reply
marcus_sommer

There is no macro-code else just a normal script to load from an Excel. If this loaded you will have a table within the data-model which you could display within the UI in a table-chart.