Questions tagged [data-comparison]
74 questions
0
votes
2 answers
How do I match fields with different formats and data types?
So if I have the following fields in two different tables
TABLE 1 | TABLE 2
Itm_ID (VARCHAR2) | Itm_ID (NUMBER)
99-11-22 | 991122
12-33-44 | …
Johnson Gale
- 155
- 1
- 11
0
votes
3 answers
Prediciting time or compression ratio for lossless compress of a file?
How would one be able to predict execution time and/or resulting compression ratio when compressing a file using a certain lossless compression algorithm? I am especially more concerned with local compression, since if you know time and compression…
22332112
- 2,337
- 5
- 21
- 42
0
votes
2 answers
Best way to compare contents of two tables in Teradata?
When you need to compare two tables to see what the differences are, are there any tools or shortcuts you use, or do you handcode the SQL to compare the two tables?
Basically the core features of a product like Red Gate SQL Data Compare (schemas for…
Cade Roux
- 88,164
- 40
- 182
- 265
0
votes
1 answer
Excel Two columns comparison (misspelled text)
I have two columns in Microsoft Exel and each one contain a list of cars models. I want to compare the two columns, so the models that exist on the second columns and the first one become red.
The two columns are almost identical however there can…
Naourass Derouichi
- 773
- 3
- 12
- 38
0
votes
1 answer
SSIS Flat File data column compare against table's column data range
I need to develop a SSIS Package where I will need to import/use a flat file(has only 1 column) to compare each row against existing table's 2 columns(start and end column).
Flat File data -…
Aric Smith
- 3
- 5
0
votes
1 answer
data comparison oracle (source to target)
I have a query below from source this is how Active flag for target is derived
select case when active_end_date is null then 'Y' else 'N' end
from csi_item_instances cii
where instance_id = <> --- (MP.INSTALL_BASE_ID)
I am…
user803860
- 299
- 3
- 4
- 13
0
votes
1 answer
Compare 2 Mysql tables' data having same structure
I have 2 tables city_sessions_1 and city_sessions_2
Structure of both table are similar
CREATE TABLE `city_sessions_1` (
`city_id` int(11),
`session_date` date,
`start_time` varchar(12),
`end_time` varchar(12) ,
`attendance` int(11) ,
…
Imdad
- 5,942
- 4
- 33
- 53
0
votes
1 answer
How to generate summary report of VS 2010 DataCompare results
I am doing a SQL Server DB migration task. After the migration, I need compare the old and the new DB. I need generate a summary report (by another table or excel both are OK) to the requirement team to evaluate if the difference needs fix.
0
votes
3 answers
C++ warning of data comparision
I have one WORD variable in my program.
WORD hour;
But when I compare It
if(hour>=0 && hour<=18)
{
hour+=6;
}
It will generate warning
[Warning] comparison is always true due to limited range of data type
I am using Dev-C++ as IDE.
mcacorner
- 1,304
- 3
- 22
- 45
-1
votes
1 answer
SQL Procedure incorrectly checks if value exists
I'm building a Windows Forms Application with a connection to an SQL Database.
On start-up of my app, it will send some queries to the database to compare values:
Here is the code that generates the query:
private void…
Sam de Groot
- 3
- 2
-2
votes
1 answer
Comparing columns between tables
I have 10 tables from different sources that I import into a SQL Server database. I want to compare them with a table named basic_source.
What I want to do is compare each attribute in basic_source with each attribute in the other 10 tables,…
Gamal Saad
- 1
- 1
-3
votes
1 answer
Loop over columns to compare two columns at a time in a dataframe and add one summary column based on each comparison result
df1.csv
df2.csv
After executing the code below,
df1.merge(df2, on=['Customer_id'], indicator='Status', how='outer')
I get,
df3.csv
Now I want to compare whether all elements in Name_x is equal to Name_y or not, similarly for other columns as well.…
pytorch
- 77
- 1
- 9
-3
votes
2 answers
What type of web framework should be used to compare data between databases?
I want to query 2 or more Databases every day at a certain time, compare the resulting data and show the inconsistencies in a web page.
Mainly the data will match through PKs and comparison made using some column values.
So I´m reading about web…
Daniel C.
- 42
- 1
- 1
- 8
-3
votes
1 answer
field value from a table using linq c#
There are 2 identical tables with same name on different servers. Let say Table1 and Table2. I need to compare the tables and have to report if any field value is not matching. I'm using C# and Entity framework.
I was able to retrieve the rows of…
Ashi
- 21
- 6