Scrip Help

sona_sa — Thu, 23 Aug 2018 08:44:52 GMT

Hi,

Every thing is fine, But one thing i.e - For Result_field --> V_AREA,

In fld column I want V_AREA like Location, Operator etc. is available and vl column I need all the fld data --> DFT, FT, OPIOT etc.

Also if it is possible Please for all V_AREA --> remove all -, _ etc, I need only first charactor value, no any numeric like - DFT2040105, DFT2070201 etc --> DFT , For FT-RT-RB-1, FT_1.3 etc --> I need only FT, Similarly for other.

Please find the attached qvw for ref. and final output.

Regards,

Re: Scrip Help

vinieme12 — Thu, 23 Aug 2018 10:41:57 GMT

use below Script

cor:

LOAD n,

Pick(WildMatch(SubField(cor_field,':',1),'OPIOT*','DFT*','FT*','TC*'),'OPIOT','DFT','FT','TC') as newAreaFld,

SubField(cor_field,':',1) as fld, SubField(cor_field,':',2) as vl

,pick(

topic Re: Scrip Help in QlikView

Scrip Help

Re: Scrip Help