topic Re: Trim on Load in QlikView

Trim on Load

Anonymous — Wed, 13 Jan 2016 18:28:05 GMT

I would like to TRIM the values of a field to deliver a specific value(AP-EU-AM), but there is no common starting place to do a MID - LEFT or Right.

Here is the data:

WW_FIN_DLD1_CONS_BW_GL_TXN_DATA_AP_

WW_FIN_DLD1_CONS_BW_GL_TXN_DATA_EU_

WW_FIN_CAL1_CONS_BW_VC_TO_DM_OPENPER_AM_

What would be the way to do this on the Load?

Thanks!

Dan

swuehl — Wed, 13 Jan 2016 18:29:41 GMT

Maybe

LOAD

Subfield( YourField, '_', -2) as YourFieldTrimmed,

...

sunny_talwar — Wed, 13 Jan 2016 18:29:52 GMT

What is the expected output here?

Anonymous — Wed, 13 Jan 2016 18:34:46 GMT

Sunny ,

The desired output is AP, EU, AM

sunny_talwar — Wed, 13 Jan 2016 18:38:46 GMT

Then swuehl‌ should be able to get you to that output

Anonymous — Wed, 13 Jan 2016 18:39:48 GMT

Swuehl,

Field contains no data-

Subfield(Jobstream,'-',-2)as Region,

swuehl — Wed, 13 Jan 2016 18:41:11 GMT

Looks like you used a minus sign '-' as delimiter, not an underscore '_'?

sunny_talwar — Wed, 13 Jan 2016 18:41:16 GMT

Not the dash ( - ), you need to use underscore ( _ )

Subfield(Jobstream,'_',-2)as Region,

Anonymous — Wed, 13 Jan 2016 18:42:39 GMT

swuehl,

My bad on the '-', fixed it '_' and it worked just fine!

Thanks for the quick response!!

Regrds,

Dan

sunny_talwar — Wed, 13 Jan 2016 18:49:43 GMT

If you got what you needed, please mark Stefan's answer as correct to close the thread.