Join two lists in sharepoint using linked view in Sharepoint designer

I have 3 lists:

  1. Contract No: Fields[Title]
  2. Contract Info: [Contract No(lookup), Col1,Col2,Col3]
  3. Contract Ops: [Contract No(lookup), Col4,Col5,Col6]

I need to display join of last 2 list i.e. Contract Info & Contract Ops

Data in Contract No list:

Ct0023

Ct0078

Data in Contract Info list:

Ct0023 | A1 | A2 | A3

Ct0078 | A4 | A5 | A6

Data in Contract Ops list:

Ct0023 | B1 | B2 | B3

Ct0023 | B4 | B5 | B6

Ct0078 | B7 | B8 | B9

Ct0078 | B10 | B11 | B12

----->Expected Output<------

Ct0023 | A1 | A2 | A3 | B1 | B2 | B3

Ct0023 | A1 | A2 | A3 | B4 | B5 | B6

Ct0078 | A4 | A5 | A6 | B7 | B8 | B9

Ct0078 | A4 | A5 | A6 | B10 | B11 | B12

I Need out of the box solution for this and using SharePoint 2013 online.

Thanks in advance.

Replay

Category: sharepoint designer Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.126 (s). 12 q(s)