## typescript – Get particular columns with SPFx?

Im developing some web parts with SPFx and one of the things I’m trying to do is get certain coluumns from a list to display them.

I use the guide https://docs.microsoft.com/en-us/sharepoint/dev/spfx/web-parts/get-started/connect-to-sharepoint but the problem I’m having lies here …

Under “Define List Model” it is hardcoding the columns that are returned…

``````export interface ISPLists {
value: ISPList();
}

export interface ISPList {
Title: string;
Id: string;
}
``````

Would it be possible to say define a property (lets call it columnsToShow) and if that contains a comma delimited list then it would show those values?
For example if columnsToShow = “Title,CustomerID,CustomerContactNo”
that I would be able to see those values in ISPList?

Thanks
P

## Split data contained in one column into 3 columns in R

I have a dataset containing character vectors (that are really numbers) that i want to split into 3 different columns. These 3 columns have to have the 3 numbers contained in the original column.

``````Data<-data.frame(c("150 (130 to 170)", "130 (120 to 150)"))`

colnames(Data)<- "values"

Data

values
150 (130 to 170)
130 (120 to 150)``````

The result i expect is this.

``````value1       value2        value3
150          130          170
130          120          150``````

## Different SharePoint Lists with same Columns spaced differently?

I have created lists among 8 different sites which have all of the same columns, views, settings, etc. For some reason, one list looks exactly how I want it to spacing/padding wise. All of the others are a lot less spaced apart and I cannot seem to figure out why they are doing so.

I have tried altering the CSS

``````.ms-vb2 {
}
``````

and that doesn’t do anything. (That styling is how it is on the list that looks how it should.

Here is how they both look:

How its supposed to look:

How it actually looks:

## Google Sheets: Link/Sync Two Cells Dynamically (based on a third column’s data)

I want to preface this by saying this is NOT a duplicate of Sync two cells value. It’s similar, and uses the OnEdit() Function of Google Sheets, but the solution presented in that thread only works statically. This is an extension of that issue, not the same issue.

Let’s act like I work for Twitch for a second. My company uses a GSheet to keep track of all of our Monitored Streamers for the day, which includes regular streamers, partnered streams, and third-party pulls from other sources which require manual interaction. Each row includes the date, time, the name of the streamer, the stream ID, and the status – On Air, Delayed, Done.

Now, we keep the “Pulls” group on a separate subsheet, since those require actual effort on our part to go on air on time, as opposed to the normal streams which go off automatically. The “Pulls” subsheet is similar to the Monitored Streamers subsheet in that it has the date, time, name, and status of each Pull stream, but it also includes the encoder information on the same row, hence the need for a separate sheet.

Now, the way we have this done currently is that the status can only be changed from the main “Monitored Streamers” sheet, but the status is reflected in the appropriate box in “Pulls”. (Done with this function: `=IF(E9="","",IF(COUNTIF('Monitored Streamers'!E:E,E9)=0,"Not Found",VLOOKUP(E9,'Monitored Streamers'!E:G,3,FALSE)))`, which from what I understand finds the stream ID in column E then grabs and prints the status from col G, or prints “Not Found” if it can’t find the stream ID on the MS sheet.)

This is kind of awkward, since it means that when I – someone who only works with pull broadcasts – want to mark a stream as “on air”, I have to copy the stream ID from the “Pulls” sheet, go to the “Monitored Streamers” sheet, find the stream in question, mark it there, and then go all the way back to the “Pulls” sheet and repeat the process. It would be much easier if I were able to just update the status on the “Pulls” sheet and have it affect the “Monitored Streamers” sheet automatically, without disrupting the ability to change the status of the “Monitored Streamers” sheet directly.

Now, I read through Sync two cells value, but as I stated before, the answer for that thread only works on static cell placement and hardcoded sheets. Our rows move constantly, since we’re always adding and removing streams from the sheet, so this solution won’t work.

Could someone please either write a script or teach me how to write a script that links the cells in column X on subsheet 1 and subsheet 2, iff the data in column Y on S1 matches column Z on S2?

EDIT:

Actually, now that I’m reading the linked topic again, I’m realizing that what I’m really asking for is a version of that script that has abstractions of the cell ranges as opposed to hardcoding the whole thing, preferably through function parameters so we can link multiple different cells across both sheets. (Sometimes we have to change the stream ID or date and whatnot, and it would be awesome if all of those synchronized across both sheets while still allowing both to be edited.)

Thing is, I don’t know the first thing about GApps scripting, so I don’t know how to do that myself.

## In mysql, how to add a primary key and a composite key to a table so that it forbids duplicate rows, when there are null values within the columns?

Here is an example what to do to alter your table, you simply have to enter in the UNIQUE your own columns

``````CREATE TABLE table__(customer_id INT ,transaction_date date,income INT)
``````
``````INSERT INTO table__ VALUES(1,now(),100),(1,now(),101),(1,now(),102),(1,now(),103),
(2,now(),100),(2,now(),101),(2,now(),102)
``````
``````ALTER TABLE table__ ADD id BIGINT UNSIGNED AUTO_INCREMENT,
ALTER TABLE table__ MODIFY COLUMN id BIGINT FIRST;
``````
``````ALTER TABLE `table__` ADD UNIQUE `unique_index`(`customer_id`, `transaction_date`, `income`);
``````
``````SELECT * FROM table__
``````
```id | customer_id | transaction_date | income
-: | ----------: | :--------------- | -----:
1 |           1 | 2020-10-16       |    100
2 |           1 | 2020-10-16       |    101
3 |           1 | 2020-10-16       |    102
4 |           1 | 2020-10-16       |    103
5 |           2 | 2020-10-16       |    100
6 |           2 | 2020-10-16       |    101
7 |           2 | 2020-10-16       |    102
```
``````INSERT INTO table__ VALUES(1,1,now(),100)
``````
```Duplicate entry '1' for key 'table__.PRIMARY'
```

db<>fiddle here

## ms office – How to import text to columns and import numbers to text in macOS Numbers?

Windows Excel allows me to paste a body of text and in the bottom right corner of the pasted content, a menu prompt will pop up that can initiate the “Text Import Wizard” to import delimited text into columns (text separated by commas or spaces, for example). In Numbers, such an option doesn’t exist that I know of.

Second, how can I import text (including numbers) as text? With windows I can do both of these functions and with Numbers I can’t do either.

The only solution I’ve found to the first problem is to download a custom workflow that I found in this Apple Community thread: https://discussions.apple.com/thread/8293955

Other than that, I haven’t found a way to import numbers as text.

## SharePoint 2013 Issue Tracker App- Columns "Title" and "Related Issues"

I need to update the "Title" column to be a drop down option. Where do I go to change that option. It currently only allows for a "single line item".

## linear algebra – Computing SVD of matrix with repeating rows and columns

I have a gigantic matrix whose svd needs to be computed.
However the matrix actually is made of rows and columns with repetitions.

The matrix of unique rows and columns, $$M_{ij}$$ is small enough to be easily handled.
The row $$i$$ repeats $$R_i$$ times and column $$j$$ repeats $$C_j$$ times.

Given (M,R,C) is it possible to reconstruct the singular values of the full matrix from the singular values of $$M$$ alone ?

## inner product space – Understanding a proof that “the columns of a unitary matrix are orthonormal”

Goal: Let $$u_i$$ and $$u_j$$ be the $$i$$th and $$j$$th columns of unitary matrix $$U$$, respectively. We wish to show that

$$langle u_i, u_j rangle = 0, i ne j \ langle u_i, u_j rangle = 1, i = j \$$

From pg. 28 of Principles of Quantum Mechanics, the author presents two proofs of this, the second of which confuses me:

Question: Why does showing that

$$sum_k U_{ki}^star U_{kj} = delta_{ij}$$

demonstrate the goal? Here it seems that the author is equating

$$langle u_i, u_j rangle$$

with the complex dot product

$$u_i cdot u_k = sum_k overline{{u_i}_k} {u_j}_k = sum_k U_{ki}^* U_{kj}$$

but aren’t those not necessarily always the same thing?