python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - unpivot

Can I extract a number with a specific format from a column, and copy the number to a new column?

I have a spreadsheet that is used for scheduling employees, and for our purposes we use a job name and number in the same cell like so: Employee 1/1/22 1/2/22 John A ABC Job 21-1111 XYZ Job 21...
test-img

Mark Coleman

excel

join

merge

unpivot

text-extraction

Votes: 0

Answers: 1

Latest Answer

You can obtain your desired format from your input using Power Query, available in Windows Excel 2010+ and Excel/Office 365 To use Power Query Select some cell in your Data Table Data => Get&T...
test-img

Ron Rosenfeld

MYSQL use LEAST() or GREATEST() functions in WHERE CLAUSE

I Have a lot of columns to process in a query (columns result can be also NULL) and at the end i need an unique list of all pieces for a timetable (e.g. "what part of what piece i should work fir...
test-img

Silvio Oliviero

mysql

unpivot

Votes: 0

Answers: 1

Latest Answer

Consider something like: SELECT piece_type, check_date, which FROM ( SELECT piece_type, deadline1 AS check_date, 1 AS which FROM tbl WHERE deadline1 IS NOT NULL UNION A...
test-img

Rick James

How to transpose pivot data set like this (Pivot data already)

I have data set as below: And I need to transpose data like (I use Excel transpose): How to do that in SQL Server with PIVOT or UNPIVOT relational operators? I have tried, but no success. Thanks
test-img

Benzrvd

sql-server

pivot

pivot-table

transpose

unpivot

Votes: 0

Answers: 1

Latest Answer

Since we do not have any real DDL statements from you, maybe you can try out this fiddle here or see the query below. The below query uses unpivoting followed by pivoting to get the job done. select *...
test-img

DhruvJoshi

Combine multiple column into 1 column on the same table

I have an example table like this : id | Name | code1 | code2 ------------------------------ 1 | John | 001 | AC2 2 | Anna | 002 | AH5 3 | Brad | 003 | BB1 I want t...
test-img

Reus ellmy

sql

sql-server

unpivot

Votes: 0

Answers: 2

Latest Answer

You need to use a UNION or UNION ALL: SELECT id, Name, code1 As code FROM YourTable UNION SELECT id, Name, code2 As code FROM YourTable ORDER BY id, Name, ...
test-img

Richard Deeming

Posts

Questions

Blogs

Jobs