freelensia
New Member
- Joined
- Jul 2, 2017
- Messages
- 18
Hi,
I have a table called "SITES" like this:
The table is then loaded into Power Query and displayed as table SITE2
In table SITE2, I have added a new column with hard-coded text like this:
Company Site Country
freelensia www.freelensia.com Vietnam
google www.google.com USA
mrexcel mrexcel.com USA
[/CODE]
Now back at table SITE, a new row is added:
When I refresh table SITE2, I get this:
Company Site Country
freelensia www.freelensia.com Vietnam
fiverr www.fiverr.com USA
google www.google.com
mrexcel mrexcel.com USA
[/CODE]
As you can see for some reason the field Country is messed up.
Is there a way to tell Power Query to reserve the extra table in the same location? Perhaps we can tell Power Query that "Company" is the ID field and is unique on this table?
Thanks
I have a table called "SITES" like this:
Code:
Company Site
freelensia www.freelensia.com
google www.google.com
mrexcel mrexcel.com
The table is then loaded into Power Query and displayed as table SITE2
In table SITE2, I have added a new column with hard-coded text like this:
Company Site Country
freelensia www.freelensia.com Vietnam
google www.google.com USA
mrexcel mrexcel.com USA
[/CODE]
Now back at table SITE, a new row is added:
Code:
Company Site
freelensia www.freelensia.com
fiverr www.fiverr.com
google www.google.com
mrexcel www.mrexcel.com
When I refresh table SITE2, I get this:
Company Site Country
freelensia www.freelensia.com Vietnam
fiverr www.fiverr.com USA
google www.google.com
mrexcel mrexcel.com USA
[/CODE]
As you can see for some reason the field Country is messed up.
Is there a way to tell Power Query to reserve the extra table in the same location? Perhaps we can tell Power Query that "Company" is the ID field and is unique on this table?
Thanks