Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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
Highlighted

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

View solution in original post

2 Replies
Highlighted

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

View solution in original post

Highlighted
Partner
Partner

Thanks so much!