Discussion Board for collaboration on QlikView Scripting.
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],
Go to Solution.
subfield([Project ID], '-', 3) as [ProjectOffice],,
You can rename your current field with 'as' new field name,