See: https://drive.google.com/file/d/13NhT_wx0EQl2GBP1JhthqksjU0phgSFz/view?usp=sharing

Would like to denormalize this data model.

• This reply was modified 2 years, 9 months ago by  yrstruly.

I changed the schema to allow NOT NULL in my matching columns. Still i get the same output.

Duplicates involves all columns. I would like to add an index column to identify each row.

First i would like to able to have an unique identifier. Is the unique index the way to go?

I tried removing spaces and converted to uppercase case characters, still no difference in figures of match and no match.

My data source is an excel file which i imported to sql server.

The two columns that match on both tables contains duplicate values, so i cant join on that as a primary key-secondary key relationship. That is the issue.

USE [PPECB]

GO

/****** Object: Table...

• This reply was modified 2 years, 11 months ago by  yrstruly.
• This reply was modified 2 years, 11 months ago by  yrstruly.

fbocode contains duplicates and the id column doesn't match to build a relationship. Im starting to think that this particular table is not suppose to be in the model. It...

Its dummy data.

Please see:

CREATE TABLE [dbo].[Order](

[uid] [bigint] NULL,

[delivery_address] [nvarchar](256) NULL,

[complex_unit_no] [nvarchar](200) NULL,

[delivery_latitude] [nvarchar](20) NULL,

[delivery_longitude] [nvarchar](20) NULL,

[store_uid] [bigint] NULL,

[app_version] [nvarchar](10) NULL,

[delivery_fee] [nvarchar](10) NULL,

[amended_delivery_fee] [nvarchar](10) NULL,

[bottles_fee] [nvarchar](10) NULL,

[amended_bottles_fee] [nvarchar](10) NULL,

[promo_code] [nvarchar](50) NULL,

[promo_discount] [nvarchar](10) NULL,

[promo_discount_amount]...

I could connect ODBC using this string"Driver={Mysql ODBC 8.0 ANSI Driver};Server=Localhost;Database=Marketing;UID=Marketing;PWD=Musica123;" now i am getting this error:

TITLE: Microsoft Visual Studio

------------------------------

Pipeline component has returned HRESULT error code 0xC0208457 from a method...

Getting errors when using the odbc string connection:

When i use the MYSQL connector, i am getting this messages below. I do create the table with mysql code.

Only the three tables given.

USE [Edu]

GO

/****** Object: Table [dbo].[Opp...] Script Date: 2021/11/26 16:15:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Opp...](

[id] [float] NULL,

[contact_id] [float] NULL,

[created_at] [nvarchar](255) NULL,

[fields] [nvarchar](255) NULL,

[first_activity_at] [nvarchar](255) NULL,

[first_assigned_at]...

USE [Edu]

GO

/****** Object: Table [dbo].[Products] Script Date: 2021/11/26 15:16:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Products](

[id] [varchar](50) NULL,

[created_at] [varchar](50) NULL,

[description] [varchar](50) NULL,

[name] [varchar](50) NULL,

[updated_at] [varchar](50) NULL

) ON [PRIMARY]

GO

USE [Edu]

GO

/******...

See zip file.