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:



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.


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

Related post

  • How to join two lists using REST API sharepoint 2013 2015-06-11

    I have two lists with look up column. How do i join two lists using REST API call. Thanks in advance --------------Solutions------------- You use the $expand query option. For example, you have two lists: ListA and ListB. ListA has two fields: Field1

  • Join two list using multivalued lookup field with spquery 2012-04-02

    I have joined two lists with the lookup that allow single value using spquery.join. can any one help me to do for multivalue lookup --------------Solutions------------- Finally i come to point that it is not possible to join two list using lookupmult

  • Using SPServices operation 'GetListItems' how to construct a CAML Query joining two lists? 2015-08-13

    Using SP2013 - JavaScript - $().SPServices() - operation 'GetListItems' - how would I construct a CAML query that will join two lists where list 'A' has a reference to list 'B' specifically having a where clause on a text field in list 'A' as well as

  • CAML : How to Join Two List in CAML Query? 2010-11-29

    Will you please provide me help to create a join between two SharePoint lists using CAML Queries. I am using SharePoint 2010 Development Platform. Thanks in advanced. --------------Solutions------------- It's not possible to do a formal "Join" l

  • Problem with join two lists by linq 2013-04-20

    I wanna join two list and fill drop down list by specific column but i have error in join query note:c.user_id is lookup field my code lst.DataSource = (from c in dc.Complainant join u in dc.User_collec on c.User_id equals u.User_id select new { m=u.

  • Joining two lists in a single view or edit form 2012-11-05

    I'm having trouble creating a joined edit or view form from 2 lists in Sharepoint 2010. Details I have two lists in Sharepoint 2010 that have a 1:1 relationship. When a user creates an entry in the first list (call it "Requests"), this triggers

  • Is it possible in SharePoint 2013 to insert data into two list at once using REST? 2014-11-16

    I have two list for example List A and List B the List A is The parent of List B means one to many relationship Is it possible in SharePoint 2013 to have a single form that have fields from both list if a user submit the form it should first insert d

  • Can you join two lists with a user/person column and display in a DVWP? 2013-05-29

    I have two lists created in WSS 3.0: 1) User details - A custom list (person, supervisor etc) as I can't gain access to the User Information list and can't get XML Web Services to work. 2) Training details - A custom list of trainee, trainer and proc

  • Expanding list of milestones inside list of projects, all linked to timeline - SharePoint 365 2015-06-25

    I want to create a combined table/list of all major milestones for all the projects my team work on, with the milestones also shown on a timeline. The number of milestones might get over 30, so to avoid the table/list dominating the page I want it to

  • Can someone explain this code for joining two lists by the first element of each sublist? 2013-08-25

    Background (which may be skipped, unless context is needed) I've recently begun learning Mathematica (and only up to chapter 3 of Wellin), but wanted to write some code to get a better feel for syntax before reading on. I decided a good exercise woul

  • Is it possible to populate result by joining two lists throughout the site collection 2013-08-26

    Scenario is somewhat like this: I have n number of subsites and each subsite contains two lists(exactly same in all subsites) having parent child relationships using a lookup column, need to populate data from all subsites by joining on the basis of

  • C# Join two List int , remove duplicates, NO LINQ 2016-02-04

    This is the idea: I have two List<int> and I want to make a third List<int> with the above mentioned lists joined, without duplicates. I know how to use .Union but I want to make this without using LINQ. So far I have this: Console.WriteLine(&

  • Comparing Two Lists in SML using Fold/Map? 2016-02-02

    Say I have two lists, [1,2,3] and [9,2,3]. Say I'm given a third value, 2. If I want to find out if this value is in both lists, but I can only use foldl/foldr/map to do so (no let environments or custom recursion outside of map/foldr/foldl), how can

  • How to join two Drupal CCK content types in view without a node reference field, fast? 2012-04-24

    Users uploaded two csv files to create nodes for two CCK content types (Delivery Note and Payment), i.e. Delivery Payment ---------- --------- Order No. Order No. Recipient Charge Address I would like to create a view as a report for the boss: Order

  • Using Explorer View in Sharepoint 2010 - works sometimes 2014-12-18

    Some users are having issues using the Expolorer View. At first they may get the you don't have permission to do this message, but sometime if they try 3 or 4 times, poof it will then work. I tried it using a test ID with the same permissions on the

  • Sqlite: Join clause doesn't work using a View with Union All statement 2016-01-25

    I have a Sqlite database and I created a View accounts_in_transactions using Select and Union All statements as shown below: CREATE VIEW accounts_in_transactions AS SELECT transactions_data._id, ((transactions_data.value) * -1) AS value, transactions

  • List all users using Drupal Views 2013-04-28

    I am new to Drupal and Views. I need to list all the authors(users) in my drupal 7 page? Do I need to add relationships for this ? --------------Solutions------------- No. When you add a new View, in the first screen there is a GUI with menus that le

  • How to join two sharepoint 2013 lists using JSOM 2015-06-01

    I have two lists say List1 and List2 with look up column. I need to join two lists using JSOM.Am creating sharepoint hosted app using napa. Thanks in advacnce

  • Is there some out of box feature in sharePoint to join two or more SharePoint list? 2016-03-02

    I am trying to join multiple SharePoint list based on Lookup Id (or based on some common column) like how we do in Sql Server, Is there some out of box feature available in SharePoint 2013, if not then how to achieve this. --------------Solutions----

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 2.928 (s). 13 q(s)