linking tables imported from shareroom

Fri, 20 Nov 2020 18:02:30 GMT

Hey all,

I am facing following issue. I load a list of items from a MS ShareRoom into my QlikView:

Column1	Column2	Column3
QM	Qualitätsmanagement	quality management
PM	Projektmanagement	project management
...	...	...

Everything works with following load-script:

system_parameters:

LOAD [Column1] as parameters,

[Column2] as parameters_de,

[Column3] as parameters_en

FROM

[shareroom link]

(html, utf8, embedded labels, table is ...);

Now I have an additional list with several colums which one of contains parameters from the parameter list. I load them quite similar. Because I can choose multiple Items as parameter, ShareRoom lists the items like this "QM, PM, ..." so I use PurgeChar() to purge the blanks:

Column1	Column2	Column3
1	title bla	QM, PM
2	title blub	PM
3	title blaeh	...

Everything works again with following load-script:

shareroom:

LOAD [Column1] as id,

[Column2] as title,

PurgeChar([Column3],' ') as system

FROM

[shareroom link]

(html, utf8, embedded labels, table is ...);

Now I need to connect those tables, so I created a link_table:

link_table:

LOAD system,

Subfield(system,',') as parameters

Resident shareroom;

While I used the same method with my tables in Excel everything worked. But with the ShareRoom lists it doesn't work. I see the parameters doubled and they don't link while clicking them. Anyone has an idea what could be wrong? Thanks a lot!

topic linking tables imported from shareroom in QlikView

linking tables imported from shareroom