Completed

Spotfire unpivot SQL Query

I need someone help me write a SQL query to unpivot the data. I'm going to extract data from Oracle to Spotfire.

For example, I have columns "Market", "Material", "Forecast", "Actual" from Table A.

I would like to unpivot "Forecast" and "Actual" to be "Category". And all numbers in these two columns come to another column named "Value"

Skills: Microsoft SQL Server, Oracle, Tibco Spotfire

See more: query sql view dnn, query sql mobile database, tree structure query sql, microsoft sql server, ajax query sql, query sql retrieve tree table, arcgis vba query sql server, day week date sql oracle query, tree query sql, sql increase employees salaries selected column, smartgwt dynamic grid column example, oracle query columns column headings, dnn query sql, query display table names oracle sql, can find decimals column oracle query, php html query sql, uusing data adaptor aspnet query sql server database, parent child query sql server, net query sql mobile table example, parent child query sql

About the Employer:
( 2 reviews ) Piscataway, United States

Project ID: #14274134

Awarded to:

softcarve

MM. Hi, I am a sql developer. Please share the sample data if possible. Please give me some more details of your project. So that we can take things forward. Thanks.

$25 USD in 1 day
(19 Reviews)
4.7

6 freelancers are bidding on average $28 for this job

phiona06

Hi! I think it may be like this: insert into TableB (Market, Material, Category, Value) select Market, Material, 'Forecast', sum(Forecast) from TableA group by Market, Material union select Market, Material, 'Act More

$30 USD in 1 day
(12 Reviews)
3.8
smartstepsco

Hi I'm c# developer with 12 years experience on .net and MSSqlServer. I can do this for you. please send message for me to have discussion about details

$40 USD in 1 day
(4 Reviews)
3.0
rohitagarberg

MM. Hi, I am a sql developer. Please share the sample data if possible. Please give me some more details of your project. So that we can take things forward. Thanks.

$25 USD in 1 day
(2 Reviews)
1.1
ca4fil

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0