Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have two custom lists on the SharePoint website and I would like to create a list which combines/joins the two lists. Is this possible and if so what are the best methods or third party tools for achieving this?

Regards, Sharmila

share|improve this question
    
Are you actually trying to combine the lists? Or just trying to show them as joined in a view somewhere? –  Kit Menke Apr 18 '12 at 13:45
    
I need to join lists and i want to access the resulting data in a custom webpart –  sharmila Apr 19 '12 at 5:35

1 Answer 1

up vote 3 down vote accepted
  1. You can export the lists in Excel sheets. Combine them and create another list using the combined excel sheet. This way will only allow you to combine data upto that particular point of time. i.e, its not dynamic.

  2. You can combine lists using a Data view web part creating a new linked resource. Refer this blog for details. And afterwards you can export this combined Data View web part using javascript. Find all the details here for exporting. Exporting from a Data View web part would be dynamic and real time.

Good Luck .

share|improve this answer
    
Thank you:) I have the linked datasource and now I need to access this datasource in a custom webpart –  sharmila Apr 19 '12 at 5:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.