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

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

vikasmahajan — Fri, 30 Aug 2013 06:14:19 GMT

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

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

CELAMBARASAN — Fri, 30 Aug 2013 06:18:16 GMT

Could you explain it more clear?

I guess you may need ApplyMap & Mapping Load

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

vikasmahajan — Fri, 30 Aug 2013 06:24:43 GMT

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

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

jjordaan — Fri, 30 Aug 2013 06:41:47 GMT

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')

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

its_anandrjs — Fri, 30 Aug 2013 06:43:23 GMT

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

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

CELAMBARASAN — Fri, 30 Aug 2013 06:45:07 GMT

May be you need lookup function.

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