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.
