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

[vikasmahajan]

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_CODE	PROD_BATCH	EFFDATE	PB_EFF_FROM	PB_EFF_TO	PB_NBR
1CY4	CEB4A36	03/08/2013	03/08/2013	31/03/2017	22.55
1CY4	CEB4A36	03/08/2013	03/08/2013	31/03/2017	22.64
1CY4	CEB4A36	03/08/2013	03/08/2013	31/03/2017	22.76
1CY4	CEB4A36	03/08/2013	03/08/2013	31/03/2017	22.81
1CY4	CEB4A36	03/08/2013	03/08/2013	31/03/2017	22.87
1CY4	CEB4A36	01/04/2013	01/04/2013	02/08/2013	21.04
1CY4	CEB4A36	01/04/2013	01/04/2013	02/08/2013	21.13
1CY4	CEB4A36	01/04/2013	01/04/2013	02/08/2013	21.24
1CY4	CEB4A36	01/04/2013	01/04/2013	02/08/2013	21.29
1CY4	CEB4A36	01/04/2013	01/04/2013	02/08/2013	21.34
1CY4	CEB4A36	01/04/2013	01/04/2013	31/03/2017	21.34

Thanks

Vikas

[CELAMBARASAN]

Could you explain it more clear?

I guess you may need ApplyMap & Mapping Load

[vikasmahajan]

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]

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]

May be you need lookup function.

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