Discussion Board for collaboration related to QlikView App Development.
I've searched in many post but not find my answer.
I've a file that contains two columns.
- GroupName : Name of my AD Group
- Users : Liste of users tha belongs to this group, separated with ';'
It looks like this :
I want to have a final table that looks like this
Thanks for your help
Go to Solution.
I just needed the subfield() Function. (no need to add a parameter with the index number)
subfield(MEMBER,';') as Member
View solution in original post
Solution is great,
But one concern i have suppose if the subfiled is combination of ; and ,
how we will segregate to get the output correctly?
example after USER25 we have comma
That's right, I've made a short answer.
The true is I made it in 3 steps.
Fisrt step si to load my file in a unique column into a table TMP
LOAD [@1:n] as Lig_All
The second step is to load in another table the two columns using the ',' as a separator
With the FindOneOf function, I get the index of the start of my second column containing the list of users.
With the Mid function, I get the string after this index
subfield(Lig_All,',',1) as GroupName,
Mid(Lig_All,FindOneOf(Lig_All,',',1)+1) as MemberList .
The Last Step is to use the subfield Function to assign each user to his group
Subfield(MemberList,'';') as User
I hop it could help other people with the same problem.