Converting rows to columns in SharePoint Online List PowerBi Report

I have 2 SharePoint List.

Project(Project_ID, Project_Title)


Project_Tasks(Project_ID, Tasks_Title) [here Project_ID is lookup column from Project list.]

I have data as:

enter image description here

I am able to generate the following report.

enter image description here

But My requirement is to generate a report like

enter image description here

In this case, the Pivoting will not help me. I have already tried.

Please help. Any reference link, tutorial video or suggestion is most welcome

Different String output when converting csv file to tab-delimited text file in excel

In my CSV file, there are many text records without any " character at the beginning or at the end of each record. but when I convert CSV file to tab-delimited text file in excel, I got a file that some of its records begin and ends with " character. Also when I open my CSV file with another file reader like Notepad++, these characters also exist. So, please explain why this difference occurs and how can I prevent this? (How can I have same file outputs in both CSV and text format after conversion?)

Converting UTF8 Data to SQL_ASCII

I want to convert my query results from a database, which is SQL_ASCII database encoded, to UTF-8.

$  result = $  query->execute; $  converted_data = array(); foreach($  result as $  record){     $  converted_data[count($  converted_data)] = drupal_convert_to_utf8($  record->name, 'sql-ascii'); } 

I used drupal_convert_to_utf8 but it returns blank all the time. I was confused if sql-ascii should be the second parameter of drupal_convert_to_utf8. The database encoding, where the query results is fetched, is SQL_ASCII in postgres.


According to the official documentation, It

Requires the iconv, GNU recode or mbstring PHP extension.

What are they? Am I going to install/include it or what?

Converting char into int in C++ gives me different value

I tried to convert the character ð which is in ASCII encoding (the one that my program uses) equal to 11110000 in base-2 and 240 in base-10 into an int, as:

char y = 'ð'; int c = y; cout << c; 

What I think should be printed is 240, but what was actually printed is -16.
240 in decimal is 00000000 00000000 00000000 11110000 in binary, and -16 is represented by 11111111 11111111 11111111 11110000 using two’s complement (which is the one used in my program), so why did the binary places to the left of my number ‘11110000’ got filled with ones (which alter the value) instead of zeros (which don’t alter the value)?

Converting between CSS pixel, iOS point, and Android dp

I’m developing a web application that will be viewed on mobile devices and I need to determine how large in CSS pixels to make the touch targets.

The Web Content Accessibility Guidelines (WCAG) 2.1 success criterion 2.5.5 requires touch targets of at least 44 x 44 CSS pixels. Apple’s Human Interface Guidelines (HIG) for iOS recommends 44 x 44 points and Google’s Material Design guidelines recommends 48 x 48 dp.

I’d like to compare the HIG and Material Design guidelines to WCAG. How can I compare CSS pixels, iOS points, and Android dp? Preferably, I’d like to learn how to convert iOS points and Android dp to CSS pixels.

How to display duplicate column as a separated column while converting text to csv using sed commnad?

Problem Statement : Used sed commands to convert text to csv. But it contains some columns with same name, so sed command make all duplicate column as single column seperated by |.

Solution tried:

sed 's/"//g' SDC.TXT >  outout.TXT 
sed 's/\t/","/g'  outout.TXT  > outout.csv

sed -i 's/.*/"&"/' outout.csv

These commands are used to convert text to csv by removing double qoutes

But duplicate columns are getting as one string.How to make duplicate column as separate column header.

Attaching result get using this commands : enter image description here

Attaching expected result : enter image description here

Is there an algorithm or design pattern for converting an object into a string representation involving slightly complex logic?

I am trying to write code to convert a javascript object which might look like this:

var object = {   category: [     {       subcategory: true,       includedValues: ["abc", "cde"]     },     {       subcategory: false,       values: ["xyz"]     },     {       subcategory: true,       excludedValues: ["123"]     }    ],   item: {     includedIDs: [12, 23],     excludedIDs: [65,34]   } }  

Into a filter string which looks like this:

var filter = 'category(true)==["abc","cde"]&category(false)==["xyz"]&category(true)!=["123"]&item==[12,23]&item!=[65,34]' 

As you can see, it is not a trivial stringifying the JSON. What I want to know is what is this process called. I am also doing the reverse of this where I need to convert the string to the JSON object. And I am using nearley.js for that. The only fixed component of the problem is the string. The structure of the object is something I am working on and can be modified/changed. I have most of the string to JSON working. I am trying to find the best way to do the JSON to string conversion. It is my understanding that nearley is not meant to do the conversion from JSON to string. I am not sure if it can even do it. So what would be the best way/methodology to do something like this?