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!