topic Re: Separate column for only number values. in QlikView

Separate column for only number values.

Ramu — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please help me,

In Put data:

LOAD * INLINE [
ID, Set Name
1, PMP_1.2.1.2_Developer Solutions.
2, 2.5.6.21_Research
3, Methodology implementations_5.17.8.6
4, P_2.11.4.5
5, 3.3.3.11_Methods
6, ST_1.2.1_conform
7, Views_2.1_Values
8, 2.4.5.2_Key Points & Key Values.
];

I have two fields ID and set Name,

Required out Put:

ID Set Name Set value

1 PMP_1.2.1.2_Developer Solutions. 1.2.1.2
2 2.5.6.21_Research 2.5.6.21
3 Methodology implementations_5.17.8.6 5.17.8.6
4 P_2.11.4.5 2.11.4.5
5 3.3.3.11_Methods 3.3.3.11
6 ST_1.2.1_conform 1.2.1
7 Views_2.1_Values 2.1
8 2.4.5.2_Key Points & Key Values. 2.4.5.2

I want to get only Number form the set Name field above format.

Please Help me , Thanks.

Re: Separate column for only number values.

Saravanan_Desingh — Fri, 29 May 2020 13:29:31 GMT

One solution is.

tab1: LOAD * Where Flag; LOAD *, FindOneOf([Set Value],'1234567890') As Flag ; LOAD *, SubField([Set Name],'_') As [Set Value] ; LOAD * INLINE [ ID, Set Name 1, PMP_1.2.1.2_Developer Solutions. 2, 2.5.6.21_Research 3, Methodology implementations_5.17.8.6 4, P_2.11.4.5 5, 3.3.3.11_Methods 6, ST_1.2.1_conform 7, Views_2.1_Values 8, 2.4.5.2_Key Points & Key Values. ];

Re: Separate column for only number values.

Saravanan_Desingh — Fri, 29 May 2020 13:30:27 GMT

Re: Separate column for only number values.

Ramu — Mon, 01 Jun 2020 11:07:14 GMT

Hi Saran,

Thank You.

Re: Separate column for only number values.

Saravanan_Desingh — Mon, 01 Jun 2020 13:12:57 GMT

you welcome