topic Re: ¿How create a field with modifications? in QlikView

¿How create a field with modifications?

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have a column (USERNAME) in Excel file that contains a information. I need to extract some information:

Name

FME_78701234

FME_71311233

FME_11281242

FME_71241244

FME_11241241

FME_92124124

FME_71241241

FME_71241242

FME_11231233

FME_71231233

FME_71231231

I need create the next field

Name 2
78701234
71311233
11281242
71241244
11241241
92124124
71241241
71241242
11231233
71231233
71231231

I can should be filter by Name 2.

I need solve this issue in QlikSense without any change in Excel File.

Thanks

Re: ¿How create a field with modifications?

Peter_Cammaert — Fri, 22 Apr 2016 16:02:23 GMT

You're asking this in a QlikView forum. Maybe you can move this thread to the proper area? Otherwise you may get irrelevant (or no) answers...

Best,

Peter

Re: ¿How create a field with modifications?

Anonymous — Fri, 22 Apr 2016 17:01:33 GMT

Hi Juan,

One way to achieve this is by using 'mid' function in the load script. This way you can split the value and capture it in another column. Pls check the attached screen that has the load script syntax and the 2 list boxes showing the value.

Re: ¿How create a field with modifications?

swuehl — Fri, 22 Apr 2016 17:08:03 GMT

You can also use Subfield() with a delimiter '_' in your LOAD script:

LOAD

USERNAME,

Subfield(USERNAME,'_',2) as NAME2,

...

Re: ¿How create a field with modifications?

Gysbert_Wassenaar — Fri, 22 Apr 2016 17:14:30 GMT

Or one of these:

Replace(USERNAME,'FME_','') as NAME2
keepchar(USERNAME, '0123456789') as NAME2
mid(USERNAME, Index(USERNAME, '_')+1) as NAME2