Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
neena123
Partner - Creator
Partner - Creator

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
sunny_talwar

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
sunny_talwar

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
Partner - Creator
Partner - Creator
Author

Thanks so much!