Subfield

[jpjust]

Hi,

I have an expression in load script as below.

Subfield(AppName,'(',1) as AppName,

I want to apply subfield only for App names like TEST(1) not for App names like TEST(w) or sample(w)

Essentially, don't apply sub field where app names do not contain (1) 
How can I achieve it?

Thanks

[rwunderlich · Accepted solution]

if(AppName like '*(1)', Subfield(AppName,'(',1), '') as AppName,

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[MarcoWedel · Accepted solution]

another possible solution without subfield()

Left(AppName,Index(AppName,'(1)')-1)

[jpjust]

Thank you Rob!!

[jpjust]

Thank you Marco

[MarcoWedel]

You're welcome.

Please close this thread by accepting a solution. 

Thanks