Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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.