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: 
Jean1953
Contributor
Contributor

Simply dynamically load data in a sheet's table

Hello,

I am new in QlikSense and I need to load, in a simple way, data from a source to a Table in a Sheet

In my script, I loaded "member" data with this instruction:

 
membersTable:
  LOAD *
  FROM 'myFile.csv'
  (
      txt,
      unicode,
      header is 1 lines,
      delimiter is '|',
      no quotes
    );
;
 
And I want to have a sheet named "SeeMembers" with a table that display all fields in membersTable, but I don't want to add the Dimensions manually in the sheet (it takes too much time and if I modify the membersTable or the "myfile.csv" sourceFile, I will have to also modify the sheet...
 
Is it possible to tell to the Table in SeeMembers sheet, "Display all fields of membersTable", like "membersTable.*" as Dimensions ?
 
Thank you for your expertise and your answers
Labels (4)
2 Replies
Or
MVP
MVP

Not for the regular table, I believe.

You can mass-add things using the Straight Table object if you are using May 2023 or newer, though.

Or_0-1702907374990.png

 

steeefan
Luminary
Luminary

For the regular table, I suggest using the QuickTableViewer extension. I've been using it for quite a while now and would not want to miss it in my daily work. It's really helpful. You can see how it works in the video on their page.