topic Re: How to use like operator in Inline LOAD in QlikView

How to use like operator in Inline LOAD

pra_kale — Tue, 14 Mar 2017 15:11:04 GMT

Hi,

I have attached one application in which i want to use like operator in inline load..

currently i have used it in Resident load.

please help to resolve the issue.

Thanks in Advance.

Re: How to use like operator in Inline LOAD

m_woolf — Tue, 14 Mar 2017 15:15:11 GMT

Instead of:

Where GLCODE like 'SINGTOP*';

Try:

Where left(GLCODE,7) = 'SINGTOP';

Re: How to use like operator in Inline LOAD

swuehl — Tue, 14 Mar 2017 15:16:40 GMT

Not really sure what you want to achieve.

What's your issue?

All in a single load?

LOAD Policyno,

GLCODE

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE GLCODE like 'SINGTOP*';

Re: How to use like operator in Inline LOAD

pra_kale — Tue, 14 Mar 2017 15:53:34 GMT

Hi,

Thanks Stefan for help..

I almost have more than 20 To 30 lacs data and from that i want to filter data on the basis of certain GLCODES to use it further.

If i put this in where clause then it is taking lot of time so i have used it in a Residential load..but it added one more step to filter data.

So i am trying to use it in a Inline load..but I don't know how to write (GLCODE like 'SINGTOP*') in Inline load..

Re: How to use like operator in Inline LOAD

vishsaggi — Tue, 14 Mar 2017 16:09:41 GMT

Extending Stefan's where clause you can use the same in your inline load.

LOAD * INLINE [

Policyno, GLCODE

123456, PREMINCOME01-MAT

3245698, SINGTOP-MAT

456987, PREMINCOME01-REN

987456, SINGTOP-RAS

]

WHERE GLCODE Like 'SINGTOP*';

Is this what you are looking? If not can you tell us what the issue with you load ?

Re: How to use like operator in Inline LOAD

pra_kale — Tue, 14 Mar 2017 16:18:35 GMT

Hi,

I want to know how to use like operator GLCODE like 'SINGTOP*' in Inline load...e.g.

Load * Inline [

BILLFREQ

];

This will filter data where Billing Frequency is 00.

Same way i want to use like GLCODE like 'SINGTOP*' in Inline load..

Re: How to use like operator in Inline LOAD

vishsaggi — Tue, 14 Mar 2017 16:23:19 GMT

Did you try my inline load sent earlier?

Re: How to use like operator in Inline LOAD

pra_kale — Tue, 14 Mar 2017 16:34:26 GMT

Hi,

The data which i have given is sample data but actually i am having more than 20 to 30 lacs data..so i can not mentioned the way you have given.

Re: How to use like operator in Inline LOAD

vishsaggi — Tue, 14 Mar 2017 16:45:19 GMT

So, it is not going to be an INLINE load then. IS your data coming from Excel, or Database or a QVD? Send us the actual script you are using to pull those 20 or 30 m records. Did you try Preceding load.

LOAD *

Where GLCODE Like 'SINGTOP*';

LOAD Policy, GLCODE

FORM <yourdatasource>;