Skip to Content
0
Former Member
May 24, 2016 at 08:45 PM

Multiprovider based Query displaying inappropriate output

35 Views

Hello All,

I am facing a challenge in displaying the desired output via multiprovider based query..

I have a multi provider based out of two DSOs

DSO 1 - Service Order Header - CRM

Key field - VIN

VIN Dealer code RO Number Amount

ABC INXXXX 123456 100

DSO 2

Key field - Item GUID - Service Order Item - CRM

Ref GUID of Item VIN Part details Quantity

XXXXXXXXXXX ABC Brake 1

XXXXXXXXXXX ABC Battery 1

XXXXXXXXXXX ABC Tyre 1

Now my multiprovider output is as shown below

VIN Dealer code RO Number Part details

ABC INXXXX 123456 #

ABC # # Brake

ABC # # Battery

ABC # # Tyre

As the dealer code & Ro number isn't available in the Item DSO, the output has value # for all the records except the first one..

Now my challenge is

1. There are only 3 part details in the Item table for VIN 'ABC'. Hence, Ideally the output should contain only 3 records with Part details as shown in the below table

2. The dealer code & Ro number values should be available for every part record as shown in the below screenshot..

VIN Dealer code RO Number Part details

ABC INXXXX 123456 Brake

ABC INXXXX 123456 Battery

ABC INXXXX 123456 Tyre

Appreciate if you could provide some suggestions