Discussion Board for collaboration related to Creating Analytics for QlikView.
In my access database, there is fiield showing employee's identiiy but it ıncludes more than one id with ";"
such as 100;101
İn qv side 100 id ' s name Alex but because of delimited data ı can not see the name of 100 ID
How can I seperate the delimited field in two different rows to see names?
You can use subfield function.
subfield(S, ';' ,2) returns 'cde' if S is 'abc;cde;efg'
Try by loading in script
load *, subfield(fieldname,';') as new_field
Your solution makes delimited fields into one column I wanna explain in an example
In my qw
After your solution 100;101 fields are seperated but I wanna it in one column so ı can see the name of ID
LOAD * Inline [
LOAD *, SubField(ID_Name,';')as new_id Inline [
ID_Name , Name
LOAD *, ApplyMap('a',new_id) as name
drop Table b;
In actual you have many ID for that you can replace table a with excel sheet that have id and name
Just try this may be it help you....
1. if its sure that Your ID is of fixed lenght '3'
Then use this -----
Else if it is not so Then,
Else give me sample file.....