topic how to split from one column in to other column in App Development

how to split from one column in to other column

suhascool1 — Wed, 14 Feb 2024 10:08:07 GMT

i have one column eg :

in this column we have hypen (-), Underscore(_), space( ).

Project Number Column

PADJ007809-1235334

PADJ007810_1232341

PADJ007811 1235334

and split in to the multiple column as given below

Project Number	Job_ID
PADJ007809	1235334
PADJ007810	1232341
PADJ007811	1235334

Re: how to split from one column in to other column

theoat — Wed, 14 Feb 2024 10:23:17 GMT

Good morning,

It is possible to resolve this case in the script with the functions "replace" and "subfield".
You can create, since the field "Project Number Column", the fields "Project Number" and "Job_ID" like this :
subfield(replace(replace("Project Number Column",'-',' '),'_',' '),' ',1) as [Project Number],
subfield(replace(replace("Project Number Column",'-',' '),'_',' '),' ',1) as JobID

The pictures can help you.

Kind regards,
Théo ATRAGIE.

Re: how to split from one column in to other column

vincent_ardiet_ — Wed, 14 Feb 2024 10:24:24 GMT

Have you always the same kind of pattern?
For example either <projectnumber>_<jobid> , <projectnumber> <jobid> or <projectnumber>.<jobid>?
If this is the case, you can use:
Subfield(Replace(Replace([Project Number Column],'.','_'),chr(32),'_'),'_',1) as [Project Number]
,Subfield(Replace(Replace([Project Number Column],'.','_'),chr(32),'_'),'_',2) as [Job_ID]

Re: how to split from one column in to other column

suhascool1 — Wed, 14 Feb 2024 10:26:33 GMT

yes

Re: how to split from one column in to other column

Antoine04 — Wed, 14 Feb 2024 10:26:48 GMT

You can try to use the function subfield() to split your values !

Re: how to split from one column in to other column

Anil_Babu_Samineni — Wed, 14 Feb 2024 10:28:38 GMT

@suhascool1 My best approach with, You add as many messy character to Map table.

Map:

Mapping load * inline [

Source, Destination

-, %

_, %

];

LOAD [Project Number Column],

SubField(Replace(MapSubString('Map', [Project Number Column]), chr(32),'%'), '%', 1) as First,

SubField(Replace(MapSubString('Map', [Project Number Column]), chr(32),'%'), '%', 2) as Second

FROM

[https://community.qlik.com/t5/App-Development/how-to-split-from-one-column-in-to-other-column/td-p/2418675]

(html, utf8, UserAgent is 'Mozilla/5.0', embedded labels, table is @1);

Re: how to split from one column in to other column

suhascool1 — Wed, 14 Feb 2024 10:48:55 GMT

Thank you very much

now issue resolved.

Re: how to split from one column in to other column

suhascool1 — Wed, 14 Feb 2024 10:49:28 GMT

thank you