MySQL Forums
Forum List  »  MySQL for Excel

Re: Automatic Mapping
Posted by: Daniel O'Shea
Date: May 21, 2015 09:59AM

I've resolved at least being able to append somewhat, and explain a work-around below. But the issue appears to be decimal points.

If I click on rows I want using the left row selector, not just choosing the respective cells from A to Z across and select Automatic for mapping, it chooses the columns correctly.

The only issue now is on my column16 called "Beam", it is a 4-8 digit number in each cell with field type of int(11). I still get a red map, but once I drop the column17 from the first table to the second, it accepts it.

Also, other formula columns append correctly, except two that are formula calculations that return percentage numbers such as 0.030769231.

The formula is:

=(AV2-E2)/E2
335000-325000/335000 = 0.030769231

In my webcode, I have PHP view it as 3.1%. It worked before just repasting it as a value.

In changing the formula to =((AV2-E2)/E2)*100 I get 3.01 and my php data view is now correct at 3%. Maybe I'm using the wrong Field Type in MySQL?

Great, great program by the way. Saves me a lot of steps!!

Options: ReplyQuote


Subject
Views
Written By
Posted
1901
May 21, 2015 08:04AM
Re: Automatic Mapping
1207
May 21, 2015 09:59AM
910
June 02, 2015 02:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.