topic Re: Creating a New Field From Specific Data in another Field in QlikView

Creating a New Field From Specific Data in another Field

Thu, 04 Jun 2015 19:48:39 GMT

I need to create a new field in my model based on specific data from an existing field, is that possible?

Here is an example below.

I have a field in one of my tables that shows the following detail:

I need to create a new field with the data after the "IV#" so the new field would only have 'CRG1500100' .

Thank you,

Nick

b_garside — Thu, 04 Jun 2015 19:52:08 GMT

Try using the SubField() function. the delimiter will determine how it parses the values within

petter — Thu, 04 Jun 2015 19:58:19 GMT

In your load script you could have this:

LOAD

....

Trim( TextBetween( gltdes , 'IV#' , 'R:') ) AS [IV#],

.....

FROM ...... ;

Thu, 04 Jun 2015 20:23:54 GMT

Thank you Petter! That worked!