Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Scrip Help

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,

AK

1 Reply
vinieme12
Champion III
Champion III

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(

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.