Discussion Board for collaboration on QlikView Scripting.
I have a column of data that has Property Codes & Property Codes_Area Codes
I need create a column that has just the property code, that is delete the _ and data after it.
The script below works for all that have an _ but doesn't bring across those that don't
Left (code,Index(code,'_')-1),code as Property_Code1,
How can I add to this, or is there another way, so that the column of info above ends up like below
Have you tried Subfield ?
Subfield(code,'_',1) as Property_Code1
View solution in original post