topic Re: Seperate column for each employeeID column in App Development

Seperate column for each employeeID column

Raju_6952 — Tue, 06 May 2025 13:38:14 GMT

Hi all,

i am exploring a ways to extract the employee Id as sperate column for one of my requirement.

input data and output has been attached in the image below.

is there any other options expect subfield to extract as a separate field and use it as a sperate column and curious if we can use any dynamic expression to get the same output.

Thanks in Advance.

Regards,

Raju

Re: Seperate column for each employeeID column

VBD — Tue, 06 May 2025 13:40:01 GMT

Hi, you can user subfield

https://help.qlik.com/fr-FR/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/SubField.htm

Regards,

Re: Seperate column for each employeeID column

marcus_sommer — Tue, 06 May 2025 16:54:14 GMT

It couldn't be done within the UI but easily in the script by using subfield() to transform the strings into separate records and then a generic-load could be used to create such crosstable (you should have very strong reasons to build such data-structures because crosstables are quite unhandy).

Re: Seperate column for each employeeID column

ali_hijazi — Wed, 07 May 2025 11:44:13 GMT

the following script accomplishes your requirement:

Test:
Load *, index(replace(Attribute,',',''),value) as index;
Load text(EmployeeID) as EmployeeID,text(EmployeeID) as Attribute, text(subfield(EmployeeID,',')) as value;
Load * Inline [
EmployeeID
1
2,3,4
5,6,7
]
(delimiter is ';');

Generic Load EmployeeID, index ,value Resident Test;
drop table Test;