Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you explain it more clear?
I guess you may need ApplyMap & Mapping Load
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
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')
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
May be you need lookup function.
Take a look at this link http://community.qlik.com/docs/DOC-3903