How do I reference other list in calculated column?

I am new to SharePoint.

This is List A where the calculated column (Supplier) have to refer to list B enter image description here

This is list B enter image description here

This is the formula in the excel that I tried with: =IF((Sheet1!A:A = A2) * (Sheet1!C:C = “pass”), Sheet1!B:B, “no result”)

I understand when referring another list, the syntax is different in SharePoint slightly.

How can I change the formula for the SharePoint?

Kindly assist.

Thank you.

Calculation of the average of the values of a column in a matrix

I am trying to have a list of values which corresponds to the mean of the values of each column of a matrix. Here I show a quick example (my current matrix has a dimension of 1000 * 1000)

If I have matrix like this: matrixExample = {{1, 2, 3, 4}, {5, 6, 7, 8}, {9, 9, 9, 9}} I would have to obtain a list like this: mean values={5, 5.7, 6.3, 7}.

How can I do that?

Create List item Sharepoint 2010 REST with Choice column

I am trying to create one new list item in Sharepoint 2010 using REST.


var itemProperties = { 'Title': ;Raja;, //Single line String 'Expiry_x0020‌​_Date': "02/02/2016", //Date 'Permission_x0020‌​_Type': 'Add' //Choice Column };  createListItemREST('http://xyz:5000/sites/n/', 'L2', itemProperties, function(task){  console.log('Task' + task.TaskName + ' has been created');}, function(error){ console.log(JSON.stringify(error)); });  function createListItemREST(webUrl,listName, itemProperties, success, failure) {     $  .ajax({         url: webUrl + "/_vti_bin/listdata.svc/" + listName,         type: "POST",         processData: false,         contentType: "application/json;odata=verbose",         data: JSON.stringify(itemProperties),         headers: {             "Accept": "application/json;odata=verbose"         },         success: function (data) {             success(data.d);         },         error: function (data) {             failure(data.responseJSON.error);         }     }); } 

i am getting following error.

400 Bad request

{“code”:””,”message”:{“lang”:”en-US”,”value”:”Error processing request stream. The property name ‘Expiry_x0020‌​_Date’ specified for type ‘Microsoft.SharePoint.DataService.L2Item’ is not valid.”}}

Note: When trying with only Title column this coding is working.

Column Details

Title – Single Line Text

Business Justification for Access – Choice Column

Expiry Date – Date and Time

Permission Type – Choice Column

 <ViewFields xmlns="">       <FieldRef Name="Attachments" />       <FieldRef Name="LinkTitle" />       <FieldRef Name="Business_x0020_Justification_x00" />       <FieldRef Name="Expiry_x0020_Date" />       <FieldRef Name="Permission_x0020_Type" />  </ViewFields> 

SP2013 : Overriding Thumbnails column in PublishingImages library

I’m really stuck with this one, so if someone has a little time to help me on this…

What i want :

I have a pictures library in a site. It is even a PublishingImages library. a lot of my images are .PNG files. So, i want to display a thumbnail of these files along with the name and every property i could get.

What i have :

Because these are PNG files with transparent background (and a lot of time, they are white icons), Sharepoint does not generate a good thumbnail and this last turn out to be all white. So, it is not helping.

What i thought :

I understood that SP is not good with calculating PNG thumbnails and that my PNG files are converted to JPG etc.. but i would like it to render fine, ok?

So, i thought i would create a new Content Type Column, which should be a html calculated column, with a formula which takes the original path of the file and add it a rendition.

So, instead of having only “Name” and “Thumbnails”, i would have “Name”, “Thumbnail”, “Custom Thumbnail” as columns. And in Custom Thumbnials, i should have a formula which says concat(ImageURL,'?RenditionID=9') for example.

Do you know how i could manage to calculate my custom column on one other ? Do you know how i could manage to do that ?

Thanks a lot for your time and help !!

How to load 3MB txt file line by line to a column in postgresql?

I am trying to load some test data to a table which has a column called mytext which has the type TEXT. I have a txt format novel file which is 3MB in size. I am wondering if there is any easy and proper way to load the string line by line to the column mytext instead of looping it in a for loop from my client language. Thanks a lot.

SharePoint Refinement Filter Display One Column and Sort by Another Column

I have a refinement webpart on a search page with several refiners. The issue I am having is that I need to sort the refinement filters based on another column or some other way to perform a custom sort.

For example,

  • Other
  • Region 1
  • Region 2
  • Region 3

I need “Other” to be at the bottom. Not sorted alphabetically. I have custom columns created on all of the lists that define the custom order using numbers. But I can’t figure out how to use that with the refinement filters. I can only sort by name, count or number.

Thanks in advance.

Fill SharePoint People Picker from SharePoint List Column

I have a SharePoint List who has the column of type Person or Group.

In my webpart solution I am trying to use Caml Query to get the Data of the List based on Department column. Each Department is assigned with Multiple Number of Persons.

I want to fill a Dropdown to Select Person from Dropdown and the Dropdown must be filled with the data returned based on Department

I’ve gone through this but couldn’t find any solution of using my own list in SharePoint People Picker Control

Following is the Image of my List:

enter image description here

Please Help, How can I Fill People Picker Control using this List in C# Solution


Magento 2 product collection getSelect Order by Case unException Unknown column ‘name’ in ‘order clause’

I need to use ORDER BY CASE name which is product name


SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`,  `stock_status_index`.`stock_status` AS `is_salable`  FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index`  ON cat_index.product_id=e.entity_id AND cat_index.store_id=1  AND cat_index.category_id='3' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index`  ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1  ORDER BY CASE WHEN `name` LIKE '%banana%' THEN 1  WHEN `name` LIKE '%apple%' THEN 2  ELSE 3 END 

... $ collection->addCategoryFilter($ category) $ collection->getSelect()->order(new \Zend_Db_Expr("CASE WHENnameLIKE '%banana%' THEN 1 WHENnameLIKE '%apple%' THEN 2 ELSE 3 END")); ...

Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'order clause'

If do setOrder instead of order then it Works but it just order alphabetically like so:

$ collection->addCategoryFilter($ category)->setOrder('name', 'ASC');

I need Expression what is going wrong?

Combining columns into one column for csv file using python

I have csv file which consist of 500 rows which contain text values. The number of columns vary for each row. Now want to read all columns and combine them into single column. How to do it? I have written code as follow:

import csv newFile = open('T.csv', 'w') #file for converting all data to single column with newFile: writer = csv.writer(newFile) writer.writerow(["data_var"]) with open('data.csv') as csv_file: csv_reader = csv.reader(csv_file, delimiter=',')         #line_count = 0 for row in csv_reader:     for i in range(len(row)):             if(row[i]==''):                break;                curWord=row[i];                 if(curWord[0]=="#"):                     curWord=curWord.replace("#","")                 writer.writerow([curWord.lower()]) 

But I lost some values from csv file.