Splitting values

[#1]

Dear Qlikview Developers,

For an event-based data model I have around 500 events that I want to split.

There are a few components where the events excist of, and I want to split them into 2 or more variables.

For example I have:

E1 and I want to split it as "E" and "1"

1 and I  want that as 1

FE1 and I want to split it as "FE" and "1"

KPB1 and I want to split it as "KPB" and "1"

E1-3 and I want to split it as "E", "1" and "3"

DP6-4-3 and I want to split it as "DP", "6", "4" and "3"

The overall "business rule" should be all characters is the first variable, and every single number is another variable.

How can I recognise those as variables?

Thanks in advantage,

Duncan

[kaushiknsolanki]

Hi,

     Have a look at the attached example.

     Hope this helps.

Regards,

Kaushik Solanki