topic Re: Prob in Script in QlikView

Prob in Script

nikhilgarg — Mon, 30 Mar 2015 08:39:18 GMT

Hey,

In my dashboard, i am fetching data from OLEDB source. Now, there is a Field "BusinessGroup" in databse.

Now if BusinessGroup = 'ABC%' Then ABC else fetch Desk field values from flat file.

How can i do this in script??

Re: Prob in Script

Mon, 30 Mar 2015 08:41:54 GMT

hi,

Send sample of script.

you can use like

LOAD *;

select sql *

from oracle.tablename where BusinessGroup like( 'ABC%');

Regards

Vimlesh

Re: Prob in Script

senpradip007 — Mon, 30 Mar 2015 08:48:11 GMT

Can you be more collaborative?

Re: Prob in Script

pokassov — Mon, 30 Mar 2015 08:49:42 GMT

Hi Nikhil!

If I understood you correctly, you have some key field in table.

You may do this:

t1:

mapping load

keyfield,

businessgroup

from <your local file>;

oledbtable:

load

keyfield,

if(BusinessGroup='ABC%','ABC',applymap('t1',keyfield,null()) as BusinessGroup;

sql select

keyfield,

businessgroup

from <your oledb source>;

Re: Prob in Script

nikhilgarg — Mon, 30 Mar 2015 08:51:17 GMT

Well sample is like:

OLEDB connection ;

LOAD A,

if(E LIKE 'DCM%' , 'DCM' , (have to fetch Desk field value from excel sheett));

Select......

Thanks

Re: Prob in Script

nikhilgarg — Mon, 30 Mar 2015 08:52:10 GMT

Well sample is like:

OLEDB connection ;

LOAD A,

if(E LIKE 'DCM%' , 'DCM' , (have to fetch Desk field value from excel sheett));

Select......

Thanks

Re: Prob in Script

fvelascog72 — Mon, 30 Mar 2015 08:52:17 GMT

Try this:

LOAD

if([BusinessGroup] like 'ABC*', 'ABC', [Desk]) as "FIELD",

FROM.....

Re: Prob in Script

sujeetsingh — Mon, 30 Mar 2015 09:04:20 GMT

First load the data from database as well as Flat file in Qlik.

Left join or join the both based on the Key and then derive the column as

if (left(BusinessGroup,3) = 'ABC' ,ABC , Desk) as New Filed

Re: Prob in Script

nikhilgarg — Mon, 30 Mar 2015 09:16:16 GMT

Hey,

I tried your way but prob is i am loading like:

Load Table A(having business group filed)

Left Join

Load Table B(having Desk field).

So your statement is not working fine as throwing exception Desk field not found:

if (left(BusinessGroup,3) = 'ABC' ,ABC , Desk) as New Filed

Re: Prob in Script

Mon, 30 Mar 2015 09:19:37 GMT

hi,

you want to create a field or filter only ABC related data.

use wildmatch function.

Regards

Vimlesh

Re: Prob in Script

PrashantSangle — Mon, 30 Mar 2015 09:21:50 GMT

Hi,

Just simply use wildmatch() or match() with wildcharacter *

try like

if(wildmatch(BusinessGroup),'ABC*','ABC',DeskField) as new_DeskField

Use wildmatch() if you want to non case sensitive search

and

Use match() if you want to case sensitive search

Regards

Re: Prob in Script

Mon, 30 Mar 2015 09:22:37 GMT

hi,

=if(wildmatch( FIELD1, 'ABC*') as Flag

it returns 1,0 ----1 means data which will be start from ABC

0-means other than ABC

Regards

Vimlesh