i have a issue with joins here i have two qvd's tables please see bellow attachment.

[#1]

Hi all,

TAB1:

LOAD SERIAL_NUMBER,

          PARENT_SERIAL_NUMBER,

         ORDER_NUMBER,

         SHIPPED_DATE,

          MANUFACTURING_DATE,

          ORDERTYPE,

         PRODUCT_FAMLIY as ITEM_NUMBER ,

          FIRMWARE,

           WARRANTY_END_DATE

FROM

ORDER.qvd

(qvd);

TAB2:

LOAD PRODUCT_SERIAL_NUMBER,

     PRODUCT as ITEM_NUMBER,

     RMA_NUMBER,

     SHIPMENT_DATE,

     TPV_SHIPMENT_TRACKING_NUMBER,

     TPV_PO_NUMBER

FROM

RMA_FACT.qvd

(qvd);

i need to join these two table with the help of apply map function can u please help me

[Kushal_Chawda]

what is Key between both the tables? Which Fields you want to map in which table?

[#3]

1.This search is customized one for search multiple serial numbers with separated camma delimiter  here i search a serial number (WM40AE13002660  parent serial number is  MMBC13002433)it will display in 1st table so it is existing in 1st table .

2. here i search a serial number it will display in both table so it is existing  in this case both are same  (serial number and parent serial numder ). see below image 2

3.here i search multiple serial number at a time it will display only one serial number the case is here if it is unique both serial and parent serial number then only it show other it will so single number

may be i have some join issue but i cont find how i resolve this

My REQUIREMENT IS I NEED TO SHOW WHAT EVER THE SERIAL NUMBER I SEARCH I WILL DISPLAY .here i attach application please below FTA.

[prajapatiamar38]

Hi Try this

TAB1:

Mapping

LOAD

          SERIAL_NUMBER,

          PARENT_SERIAL_NUMBER,

         ORDER_NUMBER,

         SHIPPED_DATE,

          MANUFACTURING_DATE,

          ORDERTYPE,

         PRODUCT_FAMLIY as ITEM_NUMBER ,

          FIRMWARE,

           WARRANTY_END_DATE

FROM

ORDER.qvd

(qvd);

TAB2:

LOAD

     PRODUCT_SERIAL_NUMBER,

     Applymap('TAB1',ITEM_NUMBER ) As FieldName

     PRODUCT as ITEM_NUMBER,

     RMA_NUMBER,

     SHIPMENT_DATE,

     TPV_SHIPMENT_TRACKING_NUMBER,

     TPV_PO_NUMBER

FROM

RMA_FACT.qvd

(qvd);

Hope this help you

Regards

Amarnath

[#5]

hi amarnath ,

Thanks for helping me on this but its not working.

[#6]

when i run ur code it was showing mapping need 2 columns .

[prajapatiamar38]

Hi

On which field you want to map the tables?

[kuczynska]

How come you are trying to bring across more than 2 fields through your mapping load?

From QlikView Help:

A mapping table consists of two columns, the first containing comparison values and the second containing the desired mapping values

[kaushiknsolanki]

Dear Lavanya,

You need to define the Granularity of each table and then create a composite Key and then use the Join keyword to link them.

Join can be done by Mapping load, but a we know Mapping table should have only 2 fields. So in your case you will have to create a separate mapping load table for each of the field.

Regards,

Kaushik Solanki