Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
From DTC TEST CONFIG NAME string, now I have separated Operator, RAT and V_AREA on behalf of TestEnvironmentSIM1, TestEnvironmentSIM1 --> Operator, RAT1, RAT2 --> RAT
Now I want to replace for Operator to T-MOBILE D and T-MOBILE US to T-MOBILE by script level.
and
For V_AREA --> I want remove after - and _, Only I want FT and OPIOT, Thats it.
Please find the attached qvw for ref.
Thanks & Regards,
AK
You can use a Mapping tables.
I tried but not got any output.
Regards,
AK
Can you share your load script and some sample data?
Hi,
I have shared the QVW already.
Again sharing.
Regards,
AK
There are no mapping tables in your load script.
That I have removed, bcz that not coming properly. Can you fix it. So I can proceed for next.
Regards,
AK
After looking again at your script, I think mapping tables won't work.
When you are loading Field, you can do something like:
if([Final Field] = 'V_AREA',
If(left(Field,2) = 'FT','FT',
if(left(Field,5)='OPIOT','OPIOT',Field))) as NewField
Thanks,
? about T-MOIBLE
Regards,
AK
My be youcan try like below in your script of in an expression.
Subfield(Replace(Field, '-','_'), '_',1)