Stack Overflow
Stack Overflow

Questions tagged [data-comparison]

74 questions
0
votes
0 answers

SQLite data comparison on two tables with 2 million rows of data

I've been trying to find a way of comparing huge amount of data in two different tables but I am not sure if this is the correct approach. So, this is why I am asking it here to understand a problem more and getting some clarity in order to solve…
whatismyname123
  • 149
  • 1
  • 13
0
votes
1 answer

Comparing two columns using pandas

Hi I want to compare two columns in a pandas dataframe to see if a value is in any row of a column. Table: 1 | Animals_1 | Count | |-----------|--------| | Dog | 1 | | Cat | 2 | | Squirrel | 3 | Table:2 | Animals_2 | …
Harry007
  • 5
  • 2
0
votes
0 answers

Datacompy Library in Python writes Arabic letters as gibberish in the report

I am using Datacompy Library in Python to compare two dataframes that have Arabic data, the data gets encoded safely and successfully using "cp1256" encoder and Python displays the Arabic letters correctly on the console but when Datacompy starts…
Zeyad Al Mothafar
  • 1
0
votes
1 answer

Compare csv file with MySQL database

I am creating a program in Java and I need to compare if data in a csv file is exactly the same that exists on a mysql table? How can i do that? For example, i have a table "Suplyers" with columns "Id, Name and Adress". Thanks Below is the code that…
Rodrigo
  • 1
  • 4
0
votes
1 answer

Do you know why dims [product 0] do not match the length of object [1] when trying pairw.anova

I have this data: a <- c(12, 14, 16, 12, 14, 16, 12, 14, 16) b <- c(107.13, 83.01, 164.01, 113.01, 85.48, 86.08, 112.96, 82.18, 51.92) a is the factor with 3 levels 12, 14 and 16 and b is my response variable When I try to run and plot…
javier J
  • 1
  • 1
0
votes
2 answers

Is there a way to compare file vs table record with creating new mapping using Informatica?

I'm working on a scenario where I have to compare a data record which is coming from a file with the data from a table as part of validation check before loading the data file into the staging table. I have come up with a couple of possible…
Meet Rohan
  • 75
  • 2
  • 13
0
votes
1 answer

How to check if my table matches criteria in another table

I am quite new in R. This question seems to be quite common but I wasn't able to find a relevant answer from previous questions. I have data as follow: And have my maximum limitation as the following tables (each row is a separate criterion). And…
MATTHEW
  • 69
  • 8
0
votes
2 answers

SQL Server Data Compare not persisting "ON DELETE SET NULL" Foreign Key Relationship

I have a feeling this is an "only on my machine" problem. I have two SQL 2008 R2 Express databases on my box. The schema for each was created with the same scripts. The data differs. When I use EITHER Visual Studio 2010's built-in data comparison…
roufamatic
  • 18,187
  • 7
  • 57
  • 86
0
votes
0 answers

Compare two Data Base DATA with liquibase

I want to find a way to compare DATA with liquibase. I tried this liquibase.peroperties file: driver: com.microsoft.sqlserver.jdbc.SQLServerDriver classpath:mssql-jdbc-7.0.0.jre8.jar url:…
Amir Maleki
  • 389
  • 1
  • 2
  • 14
0
votes
1 answer

How to compare a file and table data in JMeter?

I have my source file as CSV format /Flat files. My Target Table is SQL Server Database. I need to compare both Source and Target and see the difference using JMeter.
Shalu Mathew
  • 1
0
votes
2 answers

How to compare a table of SQL Server to a table of MySQL

Recently we have ETL of all from MySQL to SQL Server. Obviously the datatypes have changed. Is there any way to do detail quick data comparison (irrespective of datatypes) between MySQL and SQL Server table. I understand that Except, checksum,…
suvi
  • 3
  • 1
0
votes
1 answer

Fastest way to compare multiple column values in sql server?

I have a Table in sql server consisting of 200 million records in two different servers. I need to move this table from Server 1 to Server 2. Table in server 1 can be a subset or a superset of the table in server 2. Some of the records(around 1…
Garvit Gupta
  • 1
  • 3
0
votes
0 answers

VBA Excel : How to get the deleted row and added row in latest excel file while comparing with old file

I am struggling with writing a vba code for getting the deleted rows data and added rows data in latest excel file while comparing with old excel file. example: latest workbook(WB) have 405 rows of data and old workbook(WB) have 400 rows of data.…
Ashok
  • 284
  • 2
  • 5
  • 23
0
votes
2 answers

How does mysql do multi-type comparison?

I was working on a project and due to a miscomprehension, we ended up comparing a stored int with a string in a MySql database. I ran a few test and it seems to work but I would like to know how MySql compares different datatypes. Does it convert…
wolfcall
  • 678
  • 1
  • 8
  • 18
0
votes
1 answer

Perform Visual Studio Data Compare automatically prior to running MSTest tests

I need to perform a data compare operation to refresh a dev database froma sample data database prior to running integration tests using the VS test harness. Anyone know a way to automatically configure this?
CodeGrue
  • 5,865
  • 6
  • 44
  • 62
1 2 3
4
5