Hello
I'm trying to redisplay and reorganize some data off a huge Excel
spreadsheet. I figured it would be easier to manipulate if I dumped the
data into MySQL with the help of phpMyAdmin.
I'm a newbie to MySQL and PHP and/or Perl so if someone can lead me in the
right direction to accomplish the following.
I have a database with 1 table from 5 columns of data.
Column 1 Column 2 Column 3 Column 4 Column 5
UniqueID A Param1 1Av1 1Av2 1Av3
UniqueID A Param2 2Av1 2Av2 2Av3
UniqueID A Param3 3Av1 3Av2 3Av3
UniqueID A ...
UniqueID A ...
UniqueID A ParamN Values of ParamN (")
UniqueID B Param1 1Bv1 1Bv2 1Bv3
UniqueID B Param2 2Bv1 2Bv2 2Bv3
UniqueID B Param3 3Bv1 3Bv2 3Bv3
UniqueID B ...
UniqueID B ...
UniqueID B ParamN Values of ParamN (")
UniqueID C Param1 1Cv1 1Cv2 1Cv3
UniqueID C Param2 2Cv1 2Cv2 2Cv3
UniqueID C Param3 3Cv1 3Cv2 3Cv3
UniqueID C ...
UniqueID C ...
UniqueID C ParamN Values of ParamN (")
I want to transpose these data to
Unique ID Param1 Param2 Param3 ... ParamN
A All Corresponding Values ie. v1, v2, v3 for each ID
B All Corresponding Values "
C All Corresponding Values "
The Pivot Table in Excel seems to be perfect for this except that I can't
get it to display the actual data values for each Unique ID as opposed to
Summaries, Count etc.
Any help would be appreciated.
Thanks
Charles 1 1989
i'm a bit confused by what you mean, but i doubt mysql will help you
very much. If i were in a similar situation, i'd persist with the Excel
pivot table, or, if some scripting is called for, i'd be using VBA in
Excel. For adhoc data manipulation, Access might be better.
Charles Alexander wrote: Hello
I'm trying to redisplay and reorganize some data off a huge Excel spreadsheet. I figured it would be easier to manipulate if I dumped the data into MySQL with the help of phpMyAdmin.
I'm a newbie to MySQL and PHP and/or Perl so if someone can lead me in the right direction to accomplish the following.
I have a database with 1 table from 5 columns of data.
Column 1 Column 2 Column 3 Column 4 Column 5
UniqueID A Param1 1Av1 1Av2 1Av3 UniqueID A Param2 2Av1 2Av2 2Av3 UniqueID A Param3 3Av1 3Av2 3Av3 UniqueID A ... UniqueID A ... UniqueID A ParamN Values of ParamN (")
UniqueID B Param1 1Bv1 1Bv2 1Bv3 UniqueID B Param2 2Bv1 2Bv2 2Bv3 UniqueID B Param3 3Bv1 3Bv2 3Bv3 UniqueID B ... UniqueID B ... UniqueID B ParamN Values of ParamN (")
UniqueID C Param1 1Cv1 1Cv2 1Cv3 UniqueID C Param2 2Cv1 2Cv2 2Cv3 UniqueID C Param3 3Cv1 3Cv2 3Cv3 UniqueID C ... UniqueID C ... UniqueID C ParamN Values of ParamN (")
I want to transpose these data to
Unique ID Param1 Param2 Param3 ... ParamN
A All Corresponding Values ie. v1, v2, v3 for each ID B All Corresponding Values " C All Corresponding Values "
The Pivot Table in Excel seems to be perfect for this except that I can't get it to display the actual data values for each Unique ID as opposed to Summaries, Count etc.
Any help would be appreciated.
Thanks
Charles This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Donald Tyler |
last post by:
Then the only way you can do it that I can think of is to write a PHP script
to do basically what PHPMyAdmin is trying to do but without the LOCAL in
there.
However to do that you would need to be able to place the PHP file on the
server, and I guess you probably can't do that either. Talk about catch
22...
The only other way I can think of is to install MySQL on a machine you
control, then import the data there using the method I...
|
by: Jerry Weinstein |
last post by:
Hi,
I know about stored procedures and that they can speed up data entry via the
SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record
to be inserted to the database before the procedure is executed.
I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be...
|
by: Ray in HK |
last post by:
What are the differences between LOAD DATA INFILE and LOAD DATA LOCAL INFILE
?
I found some web hosting company do not allow using LOAD DATA INFILE but
allow LOAD DATA LOCAL INFILE. The reason is for the sake of security. What
does that mean ?
|
by: eieiohh |
last post by:
MySQL 3.23.49
PHP 4.3.8
Apache 2.0.51
Hi All!
Newbie..
I had a CRM Open Source application installed and running. Windows Xp
crashed. I was able to copy the contents of the entire hard drive onto
a USB External Hard Drive. I have to assume I also copied the data. I
|
by: jrs_14618 |
last post by:
Hello All,
This post is essentially a reply a previous post/thread
here on this mailing.database.myodbc group titled:
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode
I was wondering if anybody has experienced the same issues
| |
by: rukkie |
last post by:
After a redisplay of the form, caused by errors in other fields, the
text which is in the "Observ" textarea is shifted (some 8 places) to
the right (and this each time after a redisplay). The code used in case
of redisplay is :
<tr>
<td align="right">
Observations :
</td>
<td>
|
by: Jim Coyne |
last post by:
Is there a way to have the data controls re-populated with the previous data
if an error was encountered during an insert?
I currently have the following code to display the error message, but would
like to re-populate the data:
Protected Sub DetailsView1_ItemInserted(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.DetailsViewInsertedEventArgs)
If (Not e.Exception Is Nothing) Then
lblStatus.Text = "ERROR: Data not saved."
|
by: Jankie |
last post by:
Greetings everyone !
I seek some help to retain checkbox state on redisplay.I only have one optional checkbox to indicate whether it's the user's first visit to the site
Form1:
<INPUT type="checkbox" name="guest" value="yes">
|
by: Carmine [www.thetotalsite.it] |
last post by:
Hi,
I am using ASP.Net 2.0 with the MySQL Connector .Net 5.1.2.2.
I added these lines to the web.config to make the connector.net able to
handle the SqlConnection object (and so to bind it to a grinview/formview
etc.):
<DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |