topic Re: search condition in SAP in QlikView

search condition in SAP

Sat, 18 Oct 2014 05:22:37 GMT

how to apply the search condition while fetching the data from SAP .

Whenever i tried with where condition ,its result give all the fields without data.Please help me to resolve this issue

er_mohit — Sat, 18 Oct 2014 05:33:15 GMT

Use like function with where condition.

See below

SQL Select * from tablename

WHERE Fieldname LIKE '%FRGKE%'; //here 's FRGKE is the value.

hope it helps

its_anandrjs — Sat, 18 Oct 2014 06:06:37 GMT

Use SAP Script generator template for this and there you customized your SAP scripts.

Sat, 18 Oct 2014 06:29:50 GMT

I want to implement incremental load, so want to apply where condition for date field like

date>max(today())

Sat, 18 Oct 2014 06:30:27 GMT

SAP Script generator template won't work

er_mohit — Sat, 18 Oct 2014 06:40:57 GMT

so for SAP date format is YYYYMMDD

so for Calculate the max date from SAP table as alike Qlikview Date format in which you want to convert

do this using

Date(Date#(DateField,'YYYYMMDD'),'DD-MM-YYYY')

Mon, 20 Oct 2014 05:29:13 GMT

It works

THANKU SO MUCH