topic Re: Help in QlikView

Help

nagarjuna_kotha — Thu, 02 Jul 2015 07:20:41 GMT

Hi all,

I need one help

I have one Email field.that consist all emails Dvision ,region and Branch wise.But what i want is,i want to divide that email foeld into Division , region and Branch wise.

How to do that ?

can any one help me ......

Regards,

Naga

Re: Help

arulsettu — Thu, 02 Jul 2015 07:23:16 GMT

can you post sample data

Re: Help

Thu, 02 Jul 2015 07:38:36 GMT

I guess, subfield() will help, but I agree with Arul, can you provide some rows of your data?

Re: Help

Thu, 02 Jul 2015 07:40:03 GMT

You can use SubField() function if the email has any delimiter or left/Mid function if the email has fixed number of character for each category.

If you post any sample data will help to find the exact problem.

Re: Help

avinashelite — Thu, 02 Jul 2015 07:59:10 GMT

if you have a separator for all the fields than try like this:

subfield(fieldname,separator,position of the field)

eg:

subfield(fieldname,'-',2)

here separator is - , similarly it can be , - : anything

2, if the position after the separator

Re: Help

jagan — Thu, 02 Jul 2015 08:10:13 GMT

Hi,

Try like this

Note: assuming that - as separator of email IDS

LOAD

Subfield(EmailID,'-',1) AS Dvision ,

Subfield(EmailID,'-',1) AS region,

Subfield(EmailID,'-',1) AS Branch

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Re: Help

thimma_paul — Thu, 02 Jul 2015 08:33:48 GMT

Hi Can you please give some sample data, so that, we can look on it.