Stack Overflow
Stack Overflow

Questions tagged [data-comparison]

74 questions
1
vote
1 answer

Excel columns comparison using python code

I am working with excel for comparing three columns: my idea is to compare two columns of data with a third column as a array like each value in the 3rd column should be compared with every row of the first and second column and want to extract only…
Lakshmi KrishnaKumaar
  • 39
  • 1
  • 1
  • 9
1
vote
1 answer

Fastest way to find lines in file1 which contains any keywords from file2?

I have two files. The first file has three hundred thousand records shown example (file1) and second file has one hundred thousand records, shown example (file2). I am basically doing a grep of each entry on file2 with file1 and retrieve all that…
BBJinu
  • 77
  • 6
1
vote
1 answer

Visual Studio Data Compare - Query completed with Errors

I am trying to update a db using the Data Compare functionality in VS. Once I setup which tables I want to update I can use Write Updates and my DB is updated. However, when I Export to a .sql file and try to run it from SSMS I don't get anything in…
Jason
  • 11,435
  • 24
  • 77
  • 131
1
vote
2 answers

javafx: how to check if a date is greater than today's date?

If I have: DatePicker dp = new DataPicker(); and at some point I want to know if the data is greater than today, how can I do it? Example: if I want to book a room in a hotel from 21/04/2014 well, it should be impossible because today is…
bog
  • 1,323
  • 5
  • 22
  • 34
1
vote
1 answer

Compare big gapped data columns in chart

I have these related columns: col1 data range 1500 - 3000 col2 data range 27 - 50 col3 data range 0 - 30 I want to show the relation between those columns in a chart. But as col1 is so far apart from the other I just see the line of col1 and the…
steros
  • 1,794
  • 2
  • 26
  • 60
1
vote
1 answer

Distribute a fixed range of dates within the same ID

I have a table that lists hotel reservations by ID, each with a check in and check out dates. I can sort this by ID, but I need to distribute (on a separate column) each day of the stay (Starting with the check in date and excluding the check out…
smoodin
  • 35
  • 3
1
vote
4 answers

How to display the results of multiple comparisons

If you compare two sets of data (such as two files), the differences between these sets can be displayed in two columns, or two panes, such as WinMerge does. But are there any visual paradigms to display the differences between multiple data…
devio
  • 36,858
  • 7
  • 80
  • 143
0
votes
1 answer

VS2010 Data -> Schema Comparison duplicate files

From time to time it would seem the Schema Comparison tool creates a new file for an existing table/view and swaps it out of the Database project for the old one. For example: Original file: MyViewName.view.sql New file: MyViewName_1.view.sql The…
Stafford Williams
  • 9,696
  • 8
  • 50
  • 101
0
votes
1 answer

How do i compare 2 rows from the same table (Oracle 11g)

I need to create a stored procedure that processes a table looking for rows matching on a particular id with different statuses. I know the syntax to get the row data but i have never tried comparing 2 rows from the same table before? How is it…
radu florescu
  • 4,315
  • 10
  • 60
  • 92
0
votes
0 answers

Tableau Dashboard and weblink data comparision

Dashboards from Tableau workbook are moving from weblinks, Is there any test automation tool is there to compare data and UI between tableau and weblink Dashboard. So far we are manually comparing it. Please pore suggestions. Thank you Comapring UI…
SRV
  • 1
0
votes
1 answer

Comparing two different data with time stamp

I am facing a big problem with comparing two data. One reads me data with timestamp every 1 sec and another gives me data every 2 Sec. I am confused how could I compare both data by making the data aligned to their respective timestamp. Both are on…
Sujith
  • 3
  • 2
0
votes
1 answer

merging multiple jsons into one with data export

I have a folder containing multiple json files with a data like: file1 myname, myname2, myname3, myname, myname, myname3, file 2 myname5, myname, myname2, myname5, myname3, myname3, I want a file that give my something like this: myname,…
Moeen
  • 61
  • 6
0
votes
1 answer

Hash Value comparison for Encoded/Special characters not matching between HANA and Azure SQL DB

I am working on comparing Hash Values on SAP Hana Data and Azure SQL DB Data. However, it seems Data with special/encoded characters is returning different hash values on SAP Hana DB and SQL DW, even though the Values are same. Query on Azure SQL…
Saurabh Mehta
  • 91
  • 1
  • 2
  • 9
0
votes
1 answer

How to compare data from 2 databases with different primary and foreign keys?

I need to compare 2 databases on their datas. But I have to compare only the data, not the keys, which may be different (but the relations between objets must be the same). Actually it is a need to verify the proper functioning of a data conversion…
Vi. Bu.
  • 23
  • 4
0
votes
0 answers

Is there a way to compare two contact photos via google apps script?

Right now I am running a script on a google sheet to sync contacts between two accounts. When I am updating I am comparing current vs past data. The contact photos themselves are the same most of the time, with few changes, so I don't want to have…
David Westwood
  • 61
  • 7
1 2
3
4 5