topic Re: Segregate the field in QlikView

Segregate the field

iahmadmca1 — Wed, 05 Jul 2017 06:03:41 GMT

Team,

Just I want to small help from your side, I have one column which contains the id and name I want to segregate the id separate and name separate.

Please find the below example. which I need.

source column:

TABID. Name

12345.AM_DA

2314.AMI_Test

Results:

TGB ID	TGB Name
12345	AM_DA
2314	AMI_Test

So, I request to you please write the script for segregate the one column into two.

Thanks,

Irshad Ahmad

Re: Segregate the field

Anil_Babu_Samineni — Wed, 05 Jul 2017 06:15:26 GMT

May be this?

LOAD SubField([TABID. Name], '.', 1) AS [TGB ID], SubField([TABID. Name], '.', 2) AS [TGB Name] Inline [

TABID. Name

12345.AM_DA

2314.AMI_Test

];

Re: Segregate the field

iahmadmca1 — Wed, 05 Jul 2017 06:38:43 GMT

Thanks, Anil.

Re: Segregate the field

Anil_Babu_Samineni — Wed, 05 Jul 2017 06:44:07 GMT

NP, Please close this thread by flag correct answer and helpful. that may easy understand for new users

Re: Segregate the field

iahmadmca1 — Wed, 05 Jul 2017 07:27:00 GMT

Hi Anil,

for small changes I going open the loop

could you please tell me how you can use the group by [TGB Name] in this script I tried to use group by but it is throwing error could you write the script for this.

Re: Segregate the field

Anil_Babu_Samineni — Mon, 10 Jul 2017 04:22:08 GMT

Please share full script and error image, May be

Re: Segregate the field

iahmadmca1 — Tue, 11 Jul 2017 05:43:03 GMT

Anil,

Currently, this work in the hold will let you know once it starts.

Thanks.

Irshad Ahmad

Re: Segregate the field

Chanty4u — Tue, 11 Jul 2017 10:39:47 GMT

you can try below script also:

load * Inline [

idname

12345.AM_DA

2314.AMI_Test

];

result:

LOAD *,

KeepChar(idname,'1234567890') as ID,

PurgeChar(idname,'.1234567890') as nmae

Resident a;