How to use like operator in Inline LOAD

[pra_kale]

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.

[m_woolf]

Instead of:

Where GLCODE like 'SINGTOP*';

Try:

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

[swuehl]

Not really sure what you want to achieve.

What's your issue?

All in a single load?

B:

LOAD Policyno,

     GLCODE

FROM

(ooxml, embedded labels, table is Sheet1)

WHERE GLCODE like 'SINGTOP*';

[pra_kale]

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..

[vishsaggi]

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

A:

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 ?

[pra_kale]

Hi,

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

Load * Inline [

BILLFREQ

00

];

This will filter data where Billing Frequency is 00.

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

[vishsaggi]

Did you try my inline load sent earlier?

[pra_kale]

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.

[vishsaggi]

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>;