I was trying to copy the specific records in a list from one site and want to create a new list in another site with selected records.
Sudhakar,
when you say first 1500 records, do you mean the you know the id’s would be 1-1500? If yes you can run a powershell to bulk delete items. Refer below link for bulk deleting items https://www.mavention.nl/blogs/delete-items-batch-sharepoint-list-powershell-script/
HI Chanakya,
I have copied all the items in the list from site1 to site2 list. In a site1 list, I have lookup fields with some data. After completing of copying to a site2 list, there was a missing data of lookup fields. There is no data in the lookup fields, its empty. How do I overcome this missing data in lookup fields in a site2 list?