topic Re: Example of Selecting Multiple Field Values in QlikView

Example of Selecting Multiple Field Values

SDT — Wed, 01 May 2019 15:54:59 GMT

I have one table with 14 fields that each contain data that can be looked up in another table. For example the second table has a list of stock numbers and associated information about each. The first table contains the bills of materials with a separate field for each stock number.

Can I join these or perform a lookup such that all the stock number information applies to each of the BOM fields?

Re: Example of Selecting Multiple Field Values

asinha1991 — Thu, 02 May 2019 05:23:31 GMT

I am not able to visualize your exact requirement , can you explain with some sample data?

Re: Example of Selecting Multiple Field Values

anushree1 — Thu, 02 May 2019 07:02:25 GMT

Please check the concept of Mapping Load , that should help you meet the requirement

Re: Example of Selecting Multiple Field Values

SDT — Thu, 02 May 2019 12:17:52 GMT

Looks like this might be the answer. I need to learn how to use it properly though.

Re: Example of Selecting Multiple Field Values

SDT — Thu, 02 May 2019 12:18:58 GMT

Table 1 has 10 fields that each may or may not contain a value for "stock number".
I have a lookup table with all the stock numbers and their associated descriptions and costs. I want to connect the description and cost to every field in the first table that contains a stock number.