Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

In the Edit Script how can create a new field, with an attribute from an existing

Hello all,

I would like to use an existing field called Project ID, in order to create a new field called Office ID.

Each Project ID is made up of four key areas structured like.

Project Type-ProjectYear-Project Office-ProjectCount

The length of the characters between each "-" varies, but basically I'd like to create a new field that essentially grabs the Project Office. Is this possible using something like mid?

LOAD [Project ID],

  replace(mid([Project ID], X, X), '-', '') as [ProjectOffice],

Field

Field

Regards,

Myles

1 Solution

Accepted Solutions
maxgro
MVP
MVP

load

......,

subfield([Project ID], '-', 3) as [ProjectOffice],,

......

View solution in original post

3 Replies
maxgro
MVP
MVP

load

......,

subfield([Project ID], '-', 3) as [ProjectOffice],,

......

Not applicable
Author

Thanks Massimo!

rajkumarb
Creator II
Creator II

Hi

You can rename your current field  with 'as' new field name,