Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called Owner that stores user ids like e1r1, mhtr, uert etc.
I am bringing this from a db2 field. Sometimes in each row there are multiple user ids separated by a comma.
I have another table called User_Info in qlikview, that stores first name, last name and user ids.
I need to correlate user ids from the Owner table to user ids in the USER_Info table but since there are more than one user ids in each row, I cant do that.
How do I separate user ids in the Owner table into a new row? Id appreciate the help.
Hi Diwas,
try this
LOAD SubField(Owner table , ';') AS new_ID
RESIDENT yourtable;
the answer of Eduardo in combination with a crosstable() load statement
this crosstable statement will allow you to crreate a table containing 1 row per user
once you left join this table back to the original table, this will duplicate rows (not magic, that's what a join does)