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

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

HIDING IN Table Viewer AUTOGENERATED FIELDS

During LOAD in script i have several  items like


for each File in filelist ('V:/Organisatie/ Food Group/*.*')
LOAD
'V:/Organisatie Sunkip/Food Group/' & '$(File)' as DocumentLink104,
Subfield( '$(File)' , '/', -1) as DocumentName104
autogenerate 104;
next File

Working fine 

BUT in table view they show , please see sreenshot     , since this is growing to more like this its

disturbing,  how to hide these Loads  in Table View?

 

1 Solution

Accepted Solutions
rubenmarin

Hi, All tables and fields created in script will be shown in table viewer.

You can give names to tables, maybe using the same name for all tables and adding a field with the number...Keep the fisrt one as load and use concatenate to the next tables to add rows on the intial table:

for each File...
DocumentLinks:
LOAD
'V:/Organisat...,
101 as Index
autogenerate...
for each File in filelist ('V:/Organisatie/ Food Group/*.*')
Concatenate (DocumentLinks)
LOAD
'V:/Organisat...,
109 as Index
autogenerate...

 

 

View solution in original post

2 Replies
rubenmarin

Hi, All tables and fields created in script will be shown in table viewer.

You can give names to tables, maybe using the same name for all tables and adding a field with the number...Keep the fisrt one as load and use concatenate to the next tables to add rows on the intial table:

for each File...
DocumentLinks:
LOAD
'V:/Organisat...,
101 as Index
autogenerate...
for each File in filelist ('V:/Organisatie/ Food Group/*.*')
Concatenate (DocumentLinks)
LOAD
'V:/Organisat...,
109 as Index
autogenerate...

 

 

JACKNIEKERK
Creator
Creator
Author

thanks for advise

regards Jack