topic Re: HIDING IN Table Viewer AUTOGENERATED FIELDS in QlikView

HIDING IN Table Viewer AUTOGENERATED FIELDS

JACKNIEKERK — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: HIDING IN Table Viewer AUTOGENERATED FIELDS

rubenmarin — Sun, 29 Dec 2019 18:14:49 GMT

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

Re: HIDING IN Table Viewer AUTOGENERATED FIELDS

JACKNIEKERK — Mon, 30 Dec 2019 09:06:00 GMT

thanks for advise

regards Jack