Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

how to use peek function for search while loading data into qlikview

Dear all

I have following table  i want to search values from following table  and load along with Batch Master table  key will be PROD_BATCH

how to get this. Should I use peek function ?

PROD_CODEPROD_BATCHEFFDATEPB_EFF_FROMPB_EFF_TOPB_NBR
1CY4CEB4A3603/08/201303/08/201331/03/201722.55
1CY4CEB4A3603/08/201303/08/201331/03/201722.64
1CY4CEB4A3603/08/201303/08/201331/03/201722.76
1CY4CEB4A3603/08/201303/08/201331/03/201722.81
1CY4CEB4A3603/08/201303/08/201331/03/201722.87
1CY4CEB4A3601/04/201301/04/201302/08/201321.04
1CY4CEB4A3601/04/201301/04/201302/08/201321.13
1CY4CEB4A3601/04/201301/04/201302/08/201321.24
1CY4CEB4A3601/04/201301/04/201302/08/201321.29
1CY4CEB4A3601/04/201301/04/201302/08/201321.34
1CY4CEB4A3601/04/201301/04/201331/03/201721.34

Thanks

Vikas

5 Replies
CELAMBARASAN
Partner
Partner

Could you explain it more clear?

I guess you may need ApplyMap & Mapping Load

vikasmahajan
Author

I worked on apply map giving wrong results for me .

I want to seek ( PROD_BATCH)  in Match Table and want to pick ( NBR,WEF,WETO dates )

from BAtch Master hope this clear.

Vikas

jjordaan
Partner
Partner

Maybe you can try to use the Lookup function.

lookup(fieldname, matchfieldname, matchfieldvalue [, tablename])

Returns the value of fieldname corresponding to the first occurrence of the value matchfieldvalue in the field matchfieldname.

Fieldname, matchfieldname and tablename must be given as strings (e.g. quoted literals).

The search order is load order unless the table is the result of complex operations such as joins, in which case the order is not well defined.

Both fieldname and matchfieldname must be fields in the same table, specified by tablename. If tablename is omitted the current table is assumed.

If no match is found, null is returned.

Example: lookup('Price', 'ProductID', InvoicedProd, 'pricelist')

its_anandrjs

Hi,

Please explain it more clearly as i under stand from PROD_BATCH field you want to load data of NBR,WEF,WETO i suggest use left or mid function and load data into any resident table and then join or match it with Batch master table. if you have any sample please provide it.

Thanks & Regards

CELAMBARASAN
Partner
Partner

May be you need lookup function.

Take a look at this link http://community.qlik.com/docs/DOC-3903