Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
neena123
New Contributor II

I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

The values are not all the same but some are way to long and I would like to split those values are drop the part I do not want.

For Example:

Shipping Code

ShippingDelivery_3rdDay

ShippingDelivery_2ndDay

ShippingDelivery_1stDay

Standard

Returns Gound

Worldwide

Phone_Request

Next Day Air Commercial

Next Day Air Residential

Next Day Air Early


Above I would want to take out "ShippingDelivery" and "Next Day Air" and keep all other values alone. Is this possible?

1 Solution

Accepted Solutions

Re: I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

May be like this:

MappingTable:

Mapping

LOAD * Inline [

Field1, Field2

ShippingDelivery_, ""

Next Day Air, ""

];

Table:

LOAD [Shipping Code],

  Trim(MapSubString('MappingTable', [Shipping Code])) as [Shipping Code New];

LOAD * Inline [

Shipping Code

ShippingDelivery_3rdDay

ShippingDelivery_2ndDay

ShippingDelivery_1stDay

Standard

Returns Gound

Worldwide

Phone_Request

Next Day Air Commercial

Next Day Air Residential

Next Day Air Early

];


Capture.PNG

2 Replies

Re: I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

May be like this:

MappingTable:

Mapping

LOAD * Inline [

Field1, Field2

ShippingDelivery_, ""

Next Day Air, ""

];

Table:

LOAD [Shipping Code],

  Trim(MapSubString('MappingTable', [Shipping Code])) as [Shipping Code New];

LOAD * Inline [

Shipping Code

ShippingDelivery_3rdDay

ShippingDelivery_2ndDay

ShippingDelivery_1stDay

Standard

Returns Gound

Worldwide

Phone_Request

Next Day Air Commercial

Next Day Air Residential

Next Day Air Early

];


Capture.PNG

neena123
New Contributor II

Re: I have a field with values that I would like to split up. However, not all the values are the same. Only some of them I want to split up then drop the first part of the value.

Thanks so much!