• RELEVANCY SCORE 3.80

    DB:3.80:How To Compare Two Tables Columns Data? 7s




    Hi
    I have two tables.
    Table_1 contains following columns: Flag Source Field1 Field2
    Table_2 contains following columns: Result Source TField1 TField2

    I want to take each row and Source Field1 Field2 data of Table_1 and compare with Source TField1 TField2 of Table_2. If all fields data is same then update the Result field of Table_2 with Flag field of Table_1. How to do this?

    Thanks

    DB:3.80:How To Compare Two Tables Columns Data? 7s

    I used this query and its working fine. I used sub-query because it was returning me multiple rows.

    update table_name a set a.result = (select flag from ( select FLAG, REP_CATE1, FILED1, FILED2, FILED3, FILED4, FILED5,
    FILED6, FILED7, MATCH_FIELD1, MATCH_FIELD2, SOURCE
    from table_name1 where SOURCE ='XXX')
    b where b.FILED1 = a.field1
    and b.FILED2 = a.field2
    and b.FILED3 = a.field3
    and b.FILED4 = a.field4
    and b.FILED5 = a.field5
    and b.FILED6 = abs(a.field6)
    and b.FILED7 = a.field7
    --and b.FILED1 is not null
    )
    where a.SOURCE = 'XXX'

  • RELEVANCY SCORE 3.75

    DB:3.75:How To Compare Two Columns In Expression Transformation ka





    Hi I have two columns col A and Colb Col a is from source and Column b is output from a lookup table I need to Compare in the following columns like

    Col a = (Colb + 1) if they are not equal I should through an error both the columns are of string data type

    I have added the 1 to the column but I am not able to compare the two columns can anyone let me know how to do it

    Thanks,

    Lucky

    DB:3.75:How To Compare Two Columns In Expression Transformation ka


    Hi Lucky,

    You can use IIF(COLA = v_COLB, ABORT('Reason'),'Desired Output)

    Thanks,

    Gaurav

  • RELEVANCY SCORE 3.70

    DB:3.70:How To Compare Data In Two Jtrees 31




    How to compare two trees whose node data is retrieved from database columns and display the difference in a textarea?

    My problem is like this...I have 2 emp tables from 2 database instances displayed as jtrees.So how can i compare those two trees and display the difference in textarea

    DB:3.70:How To Compare Data In Two Jtrees 31

    How to compare two trees whose node data is retrieved from database columns and display the difference in a textarea?

    My problem is like this...I have 2 emp tables from 2 database instances displayed as jtrees.So how can i compare those two trees and display the difference in textarea

  • RELEVANCY SCORE 3.67

    DB:3.67:Any Macros To List Two Folder's Data File List And Compare Their Contents? 9c



    I have a production environment and dev environment, folder structure are almost identical.

    I need to constantly compare the data in the development folder vs in the production folder.

    For example, I have dev folder, /dev, production folder /prod, both have at least dozen files.

    how do I do a proc compare on those two folders without manually input what data file is compared with what data file?

    I have the proc compare macro, but I don't know how to dynamically generate a two columns of tables and read it using the loop to do the macro.

    any test code/suggestions?

    DB:3.67:Any Macros To List Two Folder's Data File List And Compare Their Contents? 9c


    This page has programs which return lists of various items

    http://www.sascommunity.org/wiki/Making_Lists

    Ron Fehd lists maven

  • RELEVANCY SCORE 3.56

    DB:3.56:How To Compare Dates And Time 1c


    How do i compare two dates or two times against each other ?
    like if date1 date2 ?

    DB:3.56:How To Compare Dates And Time 1c

    Thank you very much. Thats what i need.

  • RELEVANCY SCORE 3.55

    DB:3.55:Flat File To Db Then Back To Flat File 1a


    I need to compare the contents of a flat file with two columns in a db table. Then do an insert into the db if there is a difference between the two and the do a select of the latest data on the db then write it to a file.
    I need help urgently, thats why i joined this forum today.

    Regards,

    Koupes

  • RELEVANCY SCORE 3.49

    DB:3.49:Problems With Listview Sorting When Altering Column Count And Type During Runtime kf


    I have a program in which I wish to display three different data subsets to the user.  I figured out how to save and load the column headers and all that.  I also figured out the sorting of the columns.  The problem is, when I change the type of data I display, the sort routine seems to refer back to the old set of columns rather than the new ones.  For instance, when I change the data displayed from 5 columns to two, and I have recently sorted the fifth column of data, then I get an error in the Compare routine during the new data load with an out of bounds index value of 4 (the index of the fifth column for the previously displayed data).  In other cases it tries to sort stuff DateTime data when the new column data for that column index is a String.  So basically the ColumnClick event still thinks you are using the old set of columns rather than the new ones I just loaded.I always do a call to ListView.Clear() before adding new column header information and new data, but while that makes the data display just fine, once the data have been sorted at least once it can throw an exception on the Compare method in the sort immediately when loading the new data.  Once you try to add the second row of data, poof.Apparently once you click on a column, that event is persistent and will continue until another column is clicked.  One solution that I would like to try is somehow return the columns to an unclicked state before I load the new data.  Barring that, any suggestions would be welcome.Thanks,David

    DB:3.49:Problems With Listview Sorting When Altering Column Count And Type During Runtime kf

    The solution was blindingly simple.  I just set my ListView.ListViewItemSorter to null when I change the columns and all is now well.  That's what I get for trying to debug after a long day.

  • RELEVANCY SCORE 3.49

    DB:3.49:Pivot Table And Chart - Show All Dates pf


    I have two sets of data that I am trying to compare with bars charts.

    One table shows events that have occurred in the last 30 days. There are two columns (Date,Event Organizer).

    The second table shows inquiries generated by those organizers. There are two columns (Date, Inquiry Source [same as event Organizer]).

    I have successfully created two bar charts (1 for each table). The problem I have is there are dates missing from each chart so it is hard to compare them visually against each other.
    How do I show all the dates from a date range whether there is data there or not? Is that possible?

    DB:3.49:Pivot Table And Chart - Show All Dates pf

    Hi,

    Upload the file on SkyDrive and share the link of the uploaded file here.

  • RELEVANCY SCORE 3.45

    DB:3.45:How To Create Single Obiee Report To Compare Selected Year Data f1


    Hi Experts,

    I Have two prompt year_to and year_from. and two columns column1 and column2.

    i want

    when we select 2012 in year_from prompt and 2013 in year_to prompt.

    Column1 should display the 2012 and column2 should display the 2013 data.

    means comparison report

    any idea how we can do it.?

    DB:3.45:How To Create Single Obiee Report To Compare Selected Year Data f1

    Hi,

    What you do is create a new analysis with two same year columns and in 1 column formula min(Year) and 2nd coulmn formula max(Year)

    In the filter year = @{pv_year} .

    now in the main report you have 2 columns rt?

    For column1 filter = filter based on another analysis select column1 (which has min(year) formula)

    For For column2 filter = filter based on another analysis select column2 (which has max(year) formula).

    Hope this will help to achieve your requirement.

    Mark If helpful/correct.

    Thanks.

  • RELEVANCY SCORE 3.40

    DB:3.40:Case Convert Counts. 78


    Hi,
    I have performed casecoversion on my data.
    Would like to know how to compare the new caseconverted colums against the original column and get counts on where the data differs. I simply want to know where two columns differ including where they have any characters which are a different case due to
    one column being caseconverted?
    Example: Name_OrigData Name_CaseConvert
    JOhn SmithJohn Smith
    Kevin ORIelly Kevin O'Rielly
    M WraspM Wrasp
    Would like to simply compare these two columns and get counts where data differs because of
    case or where actual data values are different( Ltrim(Name_OrigData) Ltrim(Name_CaseConvert))
    Ta

    DB:3.40:Case Convert Counts. 78

    Sorry to bother you folks.
    But i'll be using this to solve my prob.
    Using the COLLATE clause to dictate the case sensitiveness of the query
    SQL_Latin1_General_CP1_CS_AS
    SELECT COUNT(*)
    FROM TestData
    WHERE

    LTRIM

    (RTRIM(Name_OrigData))COLLATE
    Latin1_General_CS_AS
    LTRIM(RTRIM(Name_CaseConvert))COLLATE
    Latin1_General_CS_AS

    cheers

  • RELEVANCY SCORE 3.38

    DB:3.38:Compare Two Dates zz



    hi gurus,

    i have an internal table with 10 records.

    one of the columns is 'Modification Date' ,

    i need to get the latest of the records, ie. the date which is most recent.

    how do i acomplish this task,

    is there a function module to compare dates in an internal table.

    thanks.

    DB:3.38:Compare Two Dates zz


    Hello Sanjana-

    To get the latest record comparing date field for ex:budat.

    sort i_tab by budat ascending.

    read table i_tab into w_area index 1.

    Cheers,

    ~Srini.....

  • RELEVANCY SCORE 3.37

    DB:3.37:Compare Two Columns And Switch Values s9


    I have to columns I would like to compare. Column D and Column E. If the value in column D is greater, switch the data in the two side by side cells. For example, if D3=60 and E3=50, switch the values so that D3=50 and E3=60. Any ideas on how to accomplish
    this?

    Thank you.

    DB:3.37:Compare Two Columns And Switch Values s9

    Your welcome, it that answered the question please mark it as answered, thank you

  • RELEVANCY SCORE 3.37

    DB:3.37:How To Compare Two Columns Of Two Worksheets . 98


    I have two worksheets. I want to compare a column of sheet A with a column of sheet B .

    than delete the rows from sheet Afor which the column values of worksheetB match with the value of worksheet A

    DB:3.37:How To Compare Two Columns Of Two Worksheets . 98

    Try :

    Sub test()
    Dim i As Long
    With Sheets("SheetA")
    For i = .Cells(.Rows.Count, 1).End(xlUp).Row To 1 Step -1
    If Application.CountIf(Sheets("SheetB").Columns(1), .Cells(i, 1).Value) 0 Then
    .Cells(i, 1).EntireRow.Delete
    End If
    Next i
    End With
    End Sub

    Daniel

  • RELEVANCY SCORE 3.36

    DB:3.36:Finding Unmatched Columns From Two Tables s8


    Hello Guys,

    I am trying to compare columns from two tables based on a indexed key.

    Here is an example of what I am trying to achieve:

    Table A: A_ID A_Name A_Income A_housecount
    11 Jess 9 2
    22 Rauny 6 4

    Table B: B_ID B_Income B_housecount
    11 5 2
    22 6 4
    So in the above sample data the columns A_ID and B_Id are same in both the tables. I am trying to compare A_Income with B_Income A_housecount with B_housecount. The result set for this sample set would be:

    11 9 2
    11 5 2

    as the income in the same id is different.

    As I have large amount of data in the two tables can you please provide me some knowledge on how I can get my results? Do let me know if the explanation is not clear to you.

    Thanks in advance

    DB:3.36:Finding Unmatched Columns From Two Tables s8

    select hshold_id,hsold_income,hshold_size,
    'abc.' || case count(src1) when 0 then 'demo' else 'hshold' end the_source
    from (select hshold_id,hsold_income,hshold_size,
    1 src1,
    to_number(null) src2
    from abc.hshold
    union all
    select hshold_id,hsold_income,hshold_size,
    to_number(null) src1,
    2 src2
    from abc.demo
    )
    group by hshold_id,hsold_income,hshold_size
    having count(src1) != count(src2)Regards

    Etbin

    Edited by: Etbin on 11.2.2011 18:00
    alignement correction

  • RELEVANCY SCORE 3.36

    DB:3.36:How Do I Compare Two Documents To Easily Find Changes j8


    How does one compare two documents to easily find changes/edits/additions in Pages?

    DB:3.36:How Do I Compare Two Documents To Easily Find Changes j8

    Oops - wrong Inspector - I meant to say Document Inspector, Info Tab.Jerry

  • RELEVANCY SCORE 3.36

    DB:3.36:Compare Contents Of File With Data In Table df


    I have a file on the server and i want to run a loop to compare the contents of the file with the contents of a database table. How can i write a loop to compare the two without loading the data in a table. I wanted to know if we could use UTL_FILE.get_line to perform the comparison. Example i have 10 rows in the file and 10 rows in the table i want to know if the contents of the file exist in the table if they do then check if all the columns have the same data. If they don't then insert that data into the table.

    I appreciate any response on this topic.

    Thanks!

    DB:3.36:Compare Contents Of File With Data In Table df

    +(Wasn't aware OP reposted his question)+

    The proposed technique will never scale.I second that.

    To OP:
    From 9i and onwards external tables are the way to go to meet such requirements.

  • RELEVANCY SCORE 3.35

    DB:3.35:Need Query To Compare The Columns Of 2 Diff Tables Of 2 Different Schemas. 73


    There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).

    I want the query to compare the columns of two different tables of two different schemas and provide whether the data as well as the count of data in
    the column are same .

    if not provide the data which is not similar in the columns of two different table.

    NOTE:

    I need queries for both the cases.
    (i) The datatypes in columns of two different tables are same.
    (ii) The datatypes in columns of two different tables are diffrent.

    DB:3.35:Need Query To Compare The Columns Of 2 Diff Tables Of 2 Different Schemas. 73

    Welcome to the forum!

    Whenever you post provide your 4 digit Oracle version.

    I need queries for both the cases.

    Great - write the queries!

    The forum is not a coding service where you ask people to write code for you for free.

    YOU need to write the code. Then if you have a problem with the code you have written post the code you have written (using \ tags) and explain the problem you are having.

    Read the FAQ about how to ask a question on the forums.

  • RELEVANCY SCORE 3.31

    DB:3.31:Re: How To Compare The Plsql Table Type Reocrds z1


    Hi Michaels2,
    In my case the select statements are fetching different columns, out of which only two columns are same. So I cannot do intersect.
    Any other thought let me know.

    Thanks,
    Shaw.

    DB:3.31:Re: How To Compare The Plsql Table Type Reocrds z1

    Hi bpolarsk,
    Thanks for the suggestion, based on that I have set the line size and solved the ORA-20000: ORU-10027 error.
    But still I cannot able to store values in the plsql table type. Your code is based on predefined size array,
    but in my case it is dynamic ie., not 20. My queries may fetch n number of records, if they are
    equal then I want to store in the dynamic plsql table. Please refer my previous reply code and send your
    suggestion.
    Thanks,
    Shaw.

  • RELEVANCY SCORE 3.31

    DB:3.31:How To Compare Two Universes Of Two Different Datamarts? 3m



    Post Author: Shrikant

    CA Forum: Integrated Solutions

    Hi.. all I want to compare two universes of different data mart to check the table structure. Can anybody please tell me how to compare two Universes of different Datamarts?How i can achive this usinig BusinessObjects Enterprise XI Release 2 ??

    Thanks in advance.

    DB:3.31:How To Compare Two Universes Of Two Different Datamarts? 3m


    Post Author: Shrikant

    CA Forum: Integrated Solutions

    Hi.. all I want to compare two universes of different data mart to check the table structure. Can anybody please tell me how to compare two Universes of different Datamarts?How i can achive this usinig BusinessObjects Enterprise XI Release 2 ??

    Thanks in advance.

  • RELEVANCY SCORE 3.31

    DB:3.31:How To Export Mutilple Tables'data To One Excel? k1


    I have trouble with export mutilple tables'data to excel.
    there is the example:
    table A has two columns
    columns: no name
    data: a1 b1
    table B also has two columns
    columns: id name
    data: a2 b2
    table C has three columns
    columns: id no content
    data: a1 a2 c3
    I want to export the data which contains table A'name,table B'name to one excel using table C,how can i do?

    DB:3.31:How To Export Mutilple Tables'data To One Excel? k1

    can anyone give a method ?
    how to export a column like "row.row.dataProvider.employee.name" to excel?
    DCBindingContainer bc = getBindingContainer();
    this.containerName = bc.getName();
    JUCtrlRangeBinding tableBinding =
    (JUCtrlRangeBinding)bc.getControlBinding(getTableBindingName());

    DCIteratorBinding iter = tableBinding.getIteratorBinding();
    numberOfRows=iter.getEstimatedRowCount();

    allAttributeNames = (String[])tableBinding.getAttributeNames().clone();
    the problem is the column like "row.row.dataProvider.employee.name" is not in the
    allAttributeNames,how can i do?

  • RELEVANCY SCORE 3.30

    DB:3.30:How To Compare Varray Columns? zk


    Hi!
    Documentation says: There is no mechanism for comparing varrays.
    I have 2 tables with VARRAY column. How may I compare them based on the (not)equality of the VARRAY columns?

    DB:3.30:How To Compare Varray Columns? zk

    Hi,

    Try to create nested Table same datatype as your VARRAY.

    Example

    CREATE OR REPLACE TYPE mem_type IS VARRAY(10) of VARCHAR2(15)
    CREATE OR REPLACE TYPE nt_mem_type IS Table of VARCHAR2(15)

    CREATE TABLE club (Name VARCHAR2(10),
    Address VARCHAR2(20),
    City VARCHAR2(20),
    Phone VARCHAR2(8),
    Members mem_type)
    /

    INSERT INTO club VALUES ('AL','111 First St.','Mobile',
    '222-2222', mem_type('Brenda','Richard'));

    INSERT INTO club VALUES ('FL','222 Second St.','Orlando',
    '333-3333', mem_type('Gen','John','Steph','JJ'));

    CREATE TABLE club1 (Name VARCHAR2(10),
    Address VARCHAR2(20),
    City VARCHAR2(20),
    Phone VARCHAR2(8),
    Members mem_type)

    INSERT INTO club1 VALUES ('FL','222 Second St.','Orlando',
    '333-3333', mem_type('Gen','John','Steph','JJ'));

    Create or replace function f1 (vt1 mem_type, vt2 mem_type)
    return number
    Is

    vt11 nt_mem_type;
    vt22 nt_mem_type;

    begin
    select cast(vt1 as nt_mem_type) into vt11 from dual;
    select cast(vt2 as nt_mem_type) into vt22 from dual;

    dbms_output.put('y');

    if vt11 = vt22 then
    return 1;
    else
    return 0;
    end if;
    end;

    select * from club,club1
    where f1(club1.members,club.members) = 1 ;

  • RELEVANCY SCORE 3.29

    DB:3.29:Compare Data On Excel 8p


    I am using labview 7.1 and i having problems to compare data on two excel spreadsheet with about 30+ data and also having problems saving the data on the same spreadsheet. Like after comparing i would like to addition of value on the next column to _result.xls. Below is attached vi. Hope someone give me some ideas how to do that.






    Solved!
    Go to Solution.

  • RELEVANCY SCORE 3.27

    DB:3.27:Table_Comparison - How To Compare Data At A High Level 9k



    Hi,

    I have to do data validation at a high level between two tables that I am loading.

    I am trying to use table_comparion transform but the problem is that my target table is at a much lower level than at which I want to compare data. So it has many more columns (both key and data fields) than what I want to compare.

    Does the output of query transform ( which I am using as input into table_comparion) be in the exact same format as comparion table? If not, then can somebody suggest me something else.

    Or how can I compare output of two query transforms ?

    Thanks,

    Saurabh Bansal

    DB:3.27:Table_Comparison - How To Compare Data At A High Level 9k


    Dear Saurabh,

    Not sure if you have already got the solution to this. If yes please close the thread.

    If not, i would suggest you can use the validation rule to compare the two tables and then based on the PASS or FAIL result can check what needs to be done on the output.

    Do post back if you have got the solution or you need any furthur help or else close the question.

    regards,

    Den

  • RELEVANCY SCORE 3.27

    DB:3.27:How To Compare Two Inventory List With One Has More Items p7


    how to compare the qty of two Excel inventoryworksheet with one has more items, both has part numberand quantity columns.

    DB:3.27:How To Compare Two Inventory List With One Has More Items p7

    Hi,assuming that the part number are in column A and the quantity in column B and the longest list is in sheet1 and the shorter in Sheet2 you can bring in column C the quantities from sheet2 using

    =index(sheet2!$B$1:$B$1000,match(A2,sheet2!$A$1:$A$1000,0))

    change sheet name and range for yours

  • RELEVANCY SCORE 3.25

    DB:3.25:Compare Data From Two Tables sf



    Hi All,

    I have two columns getting the data from two different sources ( ftp and oracle database) . I am getting those two columns data in the sheet. I want to compare those two columns data values.How can i do that.

    Thanks

    DB:3.25:Compare Data From Two Tables sf


    Hello, row by row.

    Tab1:

    LOAD * INLINE [

    A, Key

    1000, 1

    1001, 2

    1002, 3

    1003, 4

    1004, 5

    1005, 6

    ];

    Join

    LOAD * INLINE [

    B, Key

    1000, 1

    1010, 2

    1020, 3

    1003, 4

    1040, 5

    , 6

    ];

    FinTable:

    LOAD A ,

    B ,

    Key,

    if(A=B, 'True', 'False') as Comparison

    Resident Tab1;

    DROP Table Tab1;

  • RELEVANCY SCORE 3.24

    DB:3.24:Compare Two Tables Data For Each Row... zd


    hi,
     I have two tables (say ParentTable ChildTable). Both tables are having same columns.
     Now i want to compare the ChildTable data with ParentTable. How i can compare the data for each row of child table and store the result in a list of bool... The  result will be 'TRUE' for a row if the data matches and result will be 'FALSE' if there is any mismatch in the data.
     Is there is any in build method to do it...? If not which is the fastest the way to do this comparison...?
    Thanks in advancs,IamHuM

    DB:3.24:Compare Two Tables Data For Each Row... zd

    Create relationship for Table1 as the Parent and Table2 as the Child. Then Copy Tables (Use Copy Method make sure you copy before adding relationship)and create another relationship for Table2 as the Parent and Table1 as the child.I'm referring to this following code from earlier posting.
    //assign relationship

    {
    ds.Relations.Add(new DataRelation(relCategories_Products, dtCat.Columns(CategoryID), dtProd.Columns(CategoryID), true));
    //Add columns
    dtProd.Columns.Add(CategoryName, typeof(System.String), Parent(relCategories_Products).CategoryName);
    //Add a Boolean Column to compare data
    dtProd.Columns.Add(VerifyColumn, typeof(System.Boolean), Parent(relCategories_Products).CategoryID = CategoryID);
    //Iterate on the boolean column to compare data
    foreach (DataRow dtRow in dtProd.Rows) {
    if (dtRow(VerifyColumn) == false) {
    break; // TODO: might not be correct. Was : Exit For
    }
    }
    }
    John

  • RELEVANCY SCORE 3.24

    DB:3.24:Compare pa


    how do i compare two dates in java

    DB:3.24:Compare pa

    You really need to read the API:
    http://java.sun.com/j2se/1.4.2/docs/api/java/util/Date.html#compareTo(java.util.Date)

  • RELEVANCY SCORE 3.24

    DB:3.24:Compare (Match) Data In Two Columns jk


    I have a single table, with multiple columns of the same datatype. I'd like to compare the first three characters of 'column a' with the first three characters of 'column b' and get a list of those that match and those that don't.
    I'm new to Oracle, so I'm not even sure where I should start. Any assistance would be appreaicated!

    Len

    DB:3.24:Compare (Match) Data In Two Columns jk

    select col_a, col_b, 'EQUAL' STATUS
    from your_table
    where upper(substr(col_a,1,3)) = upper(substr(col_b,1,3))
    union all
    select col_a, col_b, 'NONEQUAL' STATUS
    from your_table
    where upper(substr(col_a,1,3)) != upper(substr(col_b,1,3))
    union all
    select col_a, col_b, 'CANTCOMPARE' STATUS
    from your_table
    where col_a is null or col_b is null
    ;

  • RELEVANCY SCORE 3.23

    DB:3.23:Xlsx Comparisons 8k


    I'd like to know if PowerShell could be used to compare xlsx files File1 and File2. I'd like to compare columns A, B, C in each of the two files. If the record, in those three columns, match in each of the two files than that record should
    be copied to a new workbook, File3. All other non matching records would be ignored. I know there is a file comparison for csv files but I'm not sure on how to do this when comparing particular columns.
    Thank you very much,
    George Jackson

    DB:3.23:Xlsx Comparisons 8k

    Hi George,
    I‘m writing to check if the suggestions were helpful, if you have any questions, please feel free to let me know.
    If you have any feedback on our support, please clickhere.
    Best Regards,
    Anna
    TechNet Community SupportPlease remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

  • RELEVANCY SCORE 3.23

    DB:3.23:Compare Data In Sheets jp


    I have two separate sheets where I need to compare data. There are the same number of rows and columns; however the data in some of the columns should be exactly the same on both sheets. Is there a formula to help or am I stuck "eyeballing" the sheets?

    Thanks!
    Krista

  • RELEVANCY SCORE 3.23

    DB:3.23:How To Compare Columns In Different Sheets In The Same Excel..Look At The Below Explained Scenario sd



    Currently working in Datawarehousing.
    I am trying to compare the two different data source (SourceA and SouceB)which has different column name but has same data

    The following procedure i am trying to compare the data

    1) Created one excel file with two sheets in it lets say Sheet1 and Sheet2
    2)Copied data from SourceA which has 15 columns to Sheet1 with header and i have done the auto format
    3)Copied data from SourceB which has 15 columns to Sheet2 with header and i have done the auto format

    3) I have created 3rd Sheet where i am trying to put result.Look at the below sample

    SourceA Data

    SourceB Data

    Comparison Result

    PolicyId
    PolicyName
    Premium

    PolId
    PolName
    Premium

    PolIdCompare
    PolNameCompare
    PremCompare

    1001
    John
    100

    1001
    John
    100

    MATCH
    MATCH
    MATCH

    1002
    Peter
    200

    1002
    Peter
    2800

    MATCH
    MATCH
    DIFF

    1003
    Ann
    300

    1003
    Ann~~
    300

    MATCH
    DIFF
    MATCH

    1004
    Scott
    400

    2004
    Scott
    400

    DIFF
    MATCH
    DIFF

    1005
    Suren
    500

    1005
    Suren
    500

    MATCH
    MATCH
    MATCH

    Sheet1

    Sheet2

    Sheet3

    How to do the above tesing in excel. how to populat ethe result in the Sheet3 like explained above

    DB:3.23:How To Compare Columns In Different Sheets In The Same Excel..Look At The Below Explained Scenario sd

    Assuming your data is from A1 to C10 in all 3 sheets, row 1 being header, then Just go in to sheet 3 and give this formula in cell A2
    =IF(Sheet1!A2=Sheet2!A2,"Match","Diff") and then drag it downside and right side.

  • RELEVANCY SCORE 3.23

    DB:3.23:How To Compare The Data Between Two Tables Existing In Two Different Databases. zc


    Hi all,i have a EMP table in one database and another EMP table in another database, now i want to compare the data in two tables.let assume two tables have same number of columns and same column names.your information and ideas are more helpful for me.Thanks

    DB:3.23:How To Compare The Data Between Two Tables Existing In Two Different Databases. zc

    Hi all,i have a EMP table in one database and another EMP table in another database, now i want to compare the data in two tables.let assume two tables have same number of columns and same column names.your information and ideas are more helpful for me.Thanks

  • RELEVANCY SCORE 3.23

    DB:3.23:How To Compare And Adjust Two Columns In Excel 2013 as


    I need to compare two long columns (~1,500 rows) and adjust the cell contents so that matches line up and non-matches get moved up/down appropriately. It probably doesn't matter, but the values are strings. For example, if I have the following data in two
    adjacent columns:

    TESTA
    TESTA

    TESTC
    TESTB

    TESTD
    TESTC

    I'd like to end up with something like this:

    TESTA
    TESTA

    TESTB

    TESTC
    TESTC

    TESTD

    Data in both columns will be sorted alphabetically, but each column might be missing something in the other column. The end result needs to be that the lists need to have the same number of rows, and wherever there is a missing value in one column, that
    row contains a blank (or dummy value) in the other column.

    I do this manually - which is a pain - by locating a difference and then inserting a blank cell and selecting "shift cells down," which takes forever. I know how to identify a match using TRIM(CELL), and I can put a flag value in another column showing where
    there are discrepancies (or using conditional formatting), but when you shift cells around the comparison formulas break. I've even tried working with INDIRECT(), but even if I could get it to work (I can't), all it will do is flag the discrepancies, not create
    the type of end result I need.

    I've been trying to come up with something with macros or a script, but I'm out of my league here. Thanks for any advice.

    DB:3.23:How To Compare And Adjust Two Columns In Excel 2013 as

    Hi,

    You may refer to my solution at this link -
    http://www.ashishmathur.com/align-data-from-two-columns/

    I have also posted a short video of the process one has to follow.

    Hope this helps.

  • RELEVANCY SCORE 3.21

    DB:3.21:Compare Data In Two Columns And Conditionally Format 8m



    Post Author: foghat

    CA Forum: General

    Hey all, I am trying to compare data in 2 different columns - when the values are not equal I want to highlight the entire row, or even just one of the data fields. Anyone have any thoughts?Thanks.

    DB:3.21:Compare Data In Two Columns And Conditionally Format 8m


    Post Author: foghat

    CA Forum: General

    Thanks guys, I had tried something similar before posting and kept getting a 'number is required here' error - I had figured that meant I could only compare a data field against a literal number. Turns out I was getting that error because the two data fields I am trying to compare are different formats. Of course that was easily remedied and things are working like a charm now.

  • RELEVANCY SCORE 3.19

    DB:3.19:Compare Formview Data xx


    Hello, I want to compare two formview's which has almost samedata within it (labels,dropdowns etc),and set to change the colour of that particular label or dropdown which is not same so iam confused to do this do i have to compare two datasets or two
    formviews directly?lahari

    DB:3.19:Compare Formview Data xx

    Hi,
    Here are some references about LINQ to DataSet:
    http://msdn.microsoft.com/en-us/library/bb386977.aspx
    http://msdn.microsoft.com/en-us/vbasic/bb688086.aspx
    For some sample codes, you can refer to the CSLinqToDataSets and VBLinqToDataSets in All-In-One Code Framework, which is a centralized sample code library. (http://1code.codeplex.com/).
    If you need any more help, please provide uswith more detailed information.
    Thanks
    Lingzhi SunPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

  • RELEVANCY SCORE 3.19

    DB:3.19:How To Compare Data In Two Columns And Also Save The Third Column Data In The Output. sz


    This is a query about comparing data in two columns, in an Excel spreadsheet, in which there are 2500 records.
    In Column A, I have 2500 (or thereabouts) surnames. In Column D, I have 2500 (or thereabouts) surnames and in Column E, I have the corresponding first

    names, of Column D.
    What I would like to do, is to compare Column A to Column D and to put the results in Column B, with the corresponding first names of Column D, in Column C.
    The equation for comparing Column A to Column D, is ' =IF(ISERROR(MATCH(A1,$D$1:$D$2500,0)),"",A1) ', so I am wondering how I should amend that, for what I want to do?

  • RELEVANCY SCORE 3.19

    DB:3.19:Vlookup Compare The First Two Columns And Retirve 3rd Column Data Into Different Sheet 77


    Hi All,

    i need a help. how can I get compare the first two columns and get the third data into different sheet using Vlookup. I know that vlookup can use for compare one column and get the second one ex: =VLOOKUP(B12,'Database'!A$2:E$10,3,FALSE).

    to make it clear Below you can see similar example :
    The table below here is the lookup table I need to compare cloumns A B and ge the C in sheet 2.

    A B C

    1
    blue
    0.1

    1
    red
    0.1

    1
    yellow
    0.1

    2
    blue
    0.22

    2
    red
    0.22

    2
    yellow
    0.21

    3
    blue
    0.34

    3
    red
    0.33

    3
    yellow
    0.32

    ex of sheet two :

    A BC
    1 Red
    3 Blue

    what I need is I need to compare the sheet 2 columns AB in Sheet 1 and get the data in sheet 1 Coulmn C into Sheet 2. How can I do this any idea ?????

    Thank you

    Kind Regards
    NCH

    DB:3.19:Vlookup Compare The First Two Columns And Retirve 3rd Column Data Into Different Sheet 77


    Hi,

    No the columns can be anywhere and in any order. For example you can find values in Col Z and Col D and then return a value from Col A. What you MUST do though is ensure the ranges are all the same size.

    as you mention everything is working but when i tired to compare one column which is already used by formula to get the data and one normal text form giving me N/A.

    i tired serveral ways as you mention with plain text coulms which was working well when i tried the column which has formula doesnt working. if i am correct is it because that column contains formula ??

    how can i solve this#

    -NCH

  • RELEVANCY SCORE 3.18

    DB:3.18:How Do I Compare The Content Of Two Wordpad Notepad Documents Without Reading Them Line By Line 87


    How do I compare the content of two Wordpad / notepad documents without reading them line by line?

    DB:3.18:How Do I Compare The Content Of Two Wordpad Notepad Documents Without Reading Them Line By Line 87

    Hello,

    No such feature is included in the operating system.

    However, you may use your favorite search engine to look for softwares that will perform such tasks.

    THIRD PARTY SOFTWARE DISCLAIMER: Using Third Party Software, including hardware drivers can cause serious problems that may prevent your computer from booting properly. Microsoft cannot guarantee that any problems resulting
    from the use of Third Party Software can be solved. Using Third Party Software is at your own risk.

    Hope this information helps.

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Compare Two Columns In Obiee? sc


    Hi,

    I have two columns like 'abc' and 'def'. I want to display only those rows in which value of 'def' is greater than value of 'abc'. how to perform it in analysis? how to use comparison operator for columns in analysis?

    DB:3.18:How To Compare Two Columns In Obiee? sc

    Thank you..........
    Now it's working properly...........

    Thank you so much.........

  • RELEVANCY SCORE 3.17

    DB:3.17:Regarding Columns Of Number And String Datatype Comparisons 7z


    Hi all,

    I have two tables by name (table1) and (table2). table1 contains a column with a varchar2 datatype, which contains the data like (143 - delhopt). and table2 contains a column with a number datatype.

    Noow, I want to compare these two tables on the basis of these two columns. I want to extract the number 143 from table1 and compare it with table2. how can I do it? Please help me....

    DB:3.17:Regarding Columns Of Number And String Datatype Comparisons 7z

    May this would help you Dear . . .

    SELECT to_number(trim(substr('1234-abc',1,instr('1234-abc','-',1)-1))) FROM tabel1;

    Use column name of Table1 instead of "1234-abc" in the Query.

  • RELEVANCY SCORE 3.16

    DB:3.16:How Do I Compare Files? jx


    I have a file in a CVI project that I want to compare to a file with the same name in someone else project. I tried using the edit--diff feature to compare the two files, but I'm only provided with a limited list of files to compare to. How can I set this up so I canbrowse any file to compare to?

    DB:3.16:How Do I Compare Files? jx


    Hi Steve,

    The procedure described by dummy_dec is correct and will allow you to compare two files with the same filename. The tool available in CVI is rather simple, but it does give you the necessary tools to compare the two files.

    Whatare some specific details thatyou like to see in the CVI Diff tool?




    Nestor

  • RELEVANCY SCORE 3.16

    DB:3.16:How To Compare Two Tables Data Without Using Join. c9


    Hi friends,
    There are two tables which are having 40 columns each(tables
    structure is same except one table is having char columns
    other is varchar2),some corresponding columns data is same, i
    want to retrieve the data when there is a match for the columns
    without using join conditions( Since 40 columns, a big join will
    be there). Any Oracle function which will take Table names as
    arguments and compares the data..?. Please give your suggestions
    or Queries..

    Regards,
    G. Rajakumar.

    DB:3.16:How To Compare Two Tables Data Without Using Join. c9

    Hi Friends, i got the solution,

    select * from t1
    intersect
    select * from t2

    If you have any alterntives, please let me know.

    Regards,
    G. Rajakumar.

  • RELEVANCY SCORE 3.15

    DB:3.15:How To Compare Two Text File 9x


    i have 2 text file. two file have the different columns. i have to compare one row of a field to othher row one after another.

    DB:3.15:How To Compare Two Text File 9x

    Do you have delimiters in ur file when u say columns and rows . No tool will know of a column or a row diffrence without a delimiteer. If you have delimeter , you can read the complete file into a String buffer and can compare . What exactly fo you want to compare ?

  • RELEVANCY SCORE 3.14

    DB:3.14:How To Do Ms Visual Studio Data Compare Without Using Sequence Ids 3a


    I am doing a data compare with visual studio on two different databases. How do I get the data comparetoignore the sequence ID's column and only look at the rest? See I'm comparing a Test DB with a Prod DB and the sequence
    number will be out of sync anyway but I still need to compare the rest of the columns on each rowto find differences.

    DB:3.14:How To Do Ms Visual Studio Data Compare Without Using Sequence Ids 3a

    I am doing a data compare with visual studio on two different databases. How do I get the data comparetoignore the sequence ID's column and only look at the rest? See I'm comparing a Test DB with a Prod DB and the sequence
    number will be out of sync anyway but I still need to compare the rest of the columns on each rowto find differences.

  • RELEVANCY SCORE 3.14

    DB:3.14:Compare Of Two Xmltype Columns kz


    Is there a way to compare two XMLType columns to determine if they are equal?

    DB:3.14:Compare Of Two Xmltype Columns kz

    Currently there is nothing expplicit in XML DB that will help with this...

  • RELEVANCY SCORE 3.14

    DB:3.14:Comparing The Contents Of Two Tables 3s


    I would like to compare the data of two tables both of the tables has same number of columns as well data type.

    IS there anything i can query to get the mismatched data?

    thanks

    DB:3.14:Comparing The Contents Of Two Tables 3s

    Hi,

    take a look at http://www.oracle.com/technology/oramag/oracle/05-jan/o15asktom.html

    regards
    vlado

  • RELEVANCY SCORE 3.14

    DB:3.14:Compare Two Years Which Each Other 7p



    Hi!

    I'm very new to QlikView and i would now like to Compare Data of one Month in a Fiscal Year with the same Month one year before.

    If there is any other selection this should also be considered.

    How can i do that?

    DB:3.14:Compare Two Years Which Each Other 7p

    Previous Year
    Sum({Year = {'$(=Max(Year)-1)'},Month = {'$(=Max(Month))'}}Value)

    And

    Current Year
    Sum({Year = {'$(=Max(Year))'},Month = {'$(=Max(Month))'}}Value)

  • RELEVANCY SCORE 3.14

    DB:3.14:Compare Data Between Two Tables jk


    Hey Experts
    I am having two tables both are having same structure.
    Both r having 210 columns

    I want to compare data between these two tables.

    I used follwoing query

    select * from t1
    MINUS
    select * from t2but even if thr is diff in 1columns .. i need to search 210 columns which is the exact columns and data

    how can i find the exact columns out of these 210 columns ?

    DB:3.14:Compare Data Between Two Tables jk

    You Can make use of Data Dictionary tables like User_columns or all_columns.

  • RELEVANCY SCORE 3.13

    DB:3.13:Append Data ad


    Hello Guys,

    I need help in appending data to a column without deleting or changing the existing data. I have a table with two columns. I need to be able to keep adding data to one of the columns while preserving the existing data. How do I go about this.

    Thanks

    DB:3.13:Append Data ad

    Hello,

    Thanks for your reply. The datatype is Varchar2. I'll try your example when I get home and let you know.

    Regards

  • RELEVANCY SCORE 3.13

    DB:3.13:Compare Two Columns k3


    source(emp)
    -----
    ename d_ename
    --------------------------
    john john
    chris

    joe
    mary marytarget table (emp_target)
    --------------------------
    f_ename---should populate the value based on ename and d_ename. compare two columns if any of the column is null then take column which is not null. if both the columns are populated then take any of the column. it will have same values.

    Please help me how can i have value for f_ename in emp_target table.

    expected output

    f_name
    -----
    john
    chris
    joe
    marycompare two columns
    and take whatever is not null

    DB:3.13:Compare Two Columns k3

    Hi,

    As Ranit show, you can used NVL, or the sometimes faster COALESCE function.

    If you're populating the emp_target table with values from the emp table, then you can use NVL (or COALESCE) in an INSERT statement, like this:
    INSERT INTO emp_target (f_name)
    SELECT COALESCE (ename, d_ename)
    FROMemp
    ;

    I hope this answers your question.
    If not, post a little sample data (CREATE TABLE and INSERT statements, relevant columns only) for all tables involved, and also post the results you want from that data.
    If you're asking about a DML statement, such as INSERT, the sample data will be the contents of the table(s) before the DML, and the results will be state of the changed table(s) when everything is finished.
    Explain, using specific examples, how you get those results from that data.
    Always say which version of Oracle you're using (e.g., 11.2.0.2.0).
    See the forum FAQ {message:id=9360002}

  • RELEVANCY SCORE 3.13

    DB:3.13:How To Compare Two Universes ? ds



    Post Author: Shrikant

    CA Forum: Administration

    Hi.. all I want to compare two universes of different data mart to check the table structure. Can anybody please tell me how to compare two Universes of different Datamarts?How i can achive this usinig BusinessObjects Enterprise XI Release 2 ??

    Thanks in advance.

    Shrikant

    DB:3.13:How To Compare Two Universes ? ds


    Post Author: Shrikant

    CA Forum: Administration

    Hi.. all I want to compare two universes of different data mart to check the table structure. Can anybody please tell me how to compare two Universes of different Datamarts?How i can achive this usinig BusinessObjects Enterprise XI Release 2 ??

    Thanks in advance.

    Shrikant

  • RELEVANCY SCORE 3.13

    DB:3.13:How To Compare Two Columns Of Data sc


    Hi there,

    I need to compare two columns of data in Excel 2007. The data in both columns are numbers.

    I need excel tosomehow give me a list ofall the numbers that are in column A but not column B, and all the numbers that are in columnB but not column A.

    Is this possible?

    There are approx 17,000 rows of data.

    If anyone could help me it willsave me many hours of manual work!

    Many thanks,
    Alison

    DB:3.13:How To Compare Two Columns Of Data sc

    Can youdescirbe the current setup of the data?

  • RELEVANCY SCORE 3.13

    DB:3.13:Combo Box How To Show 2 Columns m7



    I have a combo box that i want to see two columns in, data coming from a table that only has two columns, how do i set the properties to show both columns?

    DB:3.13:Combo Box How To Show 2 Columns m7

    I'm assuming that this is a combobox from the Control toolbox toolbar (ActiveX)
    in excel.
    If that's true, show the properties window for that combobox and look for
    columncount. Change it to 2.
    But you'll only see the pair of columns when you're selecting an item. You'll
    see just one of the pair in the combobox after the selection.
    If you want to see both items after the selection, you may want to use a listbox
    instead.
    dlsnjs wrote:

    I have a combo box that i want to see two columns in, data coming from a table that only has two columns, how do i set the properties to show both columns?

    --
    Dave Peterson

  • RELEVANCY SCORE 3.12

    DB:3.12:How Do I Compare Two Columns Of Data In Numbers To Find The Unique Results? p1


    Hello all,I'm looking for a way to compare the data from two columns so I can find the unique results and display that data in a third column. To be specific, here's what I'm doing. Column A is a list of email addresses for people I have already written. Column B is a list of email addresses for people I would like to contact. I am not sure if there are email address from Column A in Column B, but there may be and if there are, I must find out so that I don't send a second email to these recipients. How can I have Numbers look at both columns and tell me which email addresses in Column B are not in Column A?Thanks for the help!!!

    DB:3.12:How Do I Compare Two Columns Of Data In Numbers To Find The Unique Results? p1

    Thanks everyone for your insight and help. These ideas were all really useful.

  • RELEVANCY SCORE 3.12

    DB:3.12:How To Compare Two Tables And Create A View? 9z


    Hello guys,
    I have one problem that i have one table with more than 20 columns and some columns are not required in creating a view! to do this i have one table which has same no of columns and same name
    too. only problem is i don't want to do this manually to compare and remove such rows because there may be a possibility that they will introduce more columns!

    Structure is like this,
    table1:
    a1 a2 a3 a4 ..........
    1 32 34 112
    .
    .
    .
    table 2:
    a1 a2 a3 a4.....
    (only one row either 100 or 0 to all columns)

    so i need to join these two tables and put a condition that if any column in table 2 is 100 then don't take that/those column/s into the view! How to do that? Kindly help!

    thanks
    xyz

    DB:3.12:How To Compare Two Tables And Create A View? 9z

    I think you can store the column names in rows instead of columns.

    Please see:

    CREATE TABLE table1 (A1 INT,A2 INT,A3 INT)
    CREATE TABLE table2 (Col1 NVARCHAR(50),Col2 INT)

    INSERT INTO table2 SELECT NAME,0 FROM sys.columns WHERE object_id = OBJECT_ID('table1')

    UPDATE table2 SET Col2 = 100 WHERE Col1 = 'A1'

    DECLARE @sql NVARCHAR(4000)
    SET @sql = 'CREATE VIEW view1 AS SELECT '

    --SELECT @sql

    SELECT @sql = Col1',' FROM table2 WHERE Col2 = 0

    SET @sql = LEFT(@sql,LEN(@sql)-1)' FROM table1'
    EXEC(@sql)

    DROP VIEW view1
    DROP TABLE table1
    DROP TABLE table2

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Get or Request Code Sample from Microsoft
    If you have any feedback, please tell us.

    I think Jian has almost all the SQL code needed, the only thing you need is a recursive script that will loop through the Tables columns and use it to do the update instead of the line below;
    UPDATE table2 SET Col2 = 100 WHERE Col1 = 'A1'
    But I wonder if the performance hit will make such a procedure worth it?

    Edit: Further thoughts; You can have a the Tables valuesoutputtedto a txt file and use a CLR Function to loop over the results and create a SQL String based on those outputs; That way you needn't query the database multiple times to find Columns
    containing 100 to exclude. This kind of function would not create performance issues as a recursive script in the database but can be CPU intensive.
    An example of outputting and reading text files in CLR is below;
    http://www.mssqltips.com/sqlservertip/2341/use-the-sql-server-clr-to-read-and-write-text-files/

  • RELEVANCY SCORE 3.11

    DB:3.11:How To Compare Two Schemas In Oracle Sql Developer 9d


    Hello,

    I need to compare both the data and schemas details (columns etc) between two schemas on different databases (connections).

    What is the easiest and most efficient way to do this? Hopefully in Oracle Sql Developer or Sql Plus?

    Thanks.

    DB:3.11:How To Compare Two Schemas In Oracle Sql Developer 9d

    In SQL Developer go to Tools - Schema Diff !

    in SQL* Plus you will need to write PL/SQL for this.

    Amardeep Sidhu

  • RELEVANCY SCORE 3.11

    DB:3.11:Pdf Compare aj



    I am not able to do compare two PDFs with the option of CTR+TAB button in Adobe Acrobat (Version 11). Please let me know how I can do the compare?

    DB:3.11:Pdf Compare aj


    This has to do with the GUI change that happened between Acrobat 9 and X. It switched from SDI to MDI, and is not likely to switch back. You can use Alt+Tab to switch between Acrobat windows now, just like with any other application.

  • RELEVANCY SCORE 3.11

    DB:3.11:Comparing Data xs



    Hi All,

    I am new to Qlikview using Qlikview 10 personal edition.

    Can anyone please let me know how to compare two different DB in qlikview.

    Having 2 databases with 3 tables each with same sets of columns..

    DB:3.11:Comparing Data xs


    Thanks .. I have done it successfully....

  • RELEVANCY SCORE 3.09

    DB:3.09:Compare Data In Two 2 Separate Access Databases - s1


    I have two (2) Access Databases MS2010 - One named PAIDINVOICES a and the other PAIDINVOICES - I need to compare the data to determine if there are duplications OR that the inforamtion contained in one matches the other and delete one of them.... how can
    I do this?

    Thanks
    Denise

    DB:3.09:Compare Data In Two 2 Separate Access Databases - s1

    You can link to the tables in each of the two databases in a single front end database and, in the front end, join the tables in a query to determine if there are duplicate invoices, and if so if the values in specific columns in the table differ. This
    does mean of course that you need primary keys, or at least candidate keys, whose values can be guaranteed to match between the two sets of invoices, e.g. an invoice number. This rules out autonumber keys, so if the tables have, for insatance, an InvoiceID
    autonumber key in each case, there would need to be another candidate key, which could be a single column or a composite key, in each table on which they can be joined.

  • RELEVANCY SCORE 3.09

    DB:3.09:Calling Javascript For Validation In Adf Table 77


    Hi All ,

    I have an ADF Application where the database is not used. Everything is coming from BPEL Processes(WebService) in ADF Application.And there are ADF tables which has binding with the POJO Based data control.Now when data renders onto ADF Table, i need to compare two inputtext of two different columns inputtext1(where application will ask user to enter the value) and another inputtext2(where the value will come from a webservice) , and accordingly need to put some custom validations.*Validation should start on valuechange event of inputtext1.*
    On value change event it should call the javascript which has logic for the validation because i need to make it AJAX call. How to compare two attributes of two columns using javascript when webservice has been used ?

    Please help !!!!!

    Thanks

    DB:3.09:Calling Javascript For Validation In Adf Table 77

    Hi,

    I don't understand what you mean by this: "On value change event it should call the javascript which has logic for the validation *because i need to make it AJAX* call"

    If the integration is through a POJO data control, then what is the Ajax call you need to make ?

    Frank

  • RELEVANCY SCORE 3.09

    DB:3.09:Data Comparison Tool cc


    Does anyone know of a comparison tool that will actually compare data, like row for row in two different data bases? I found DBComparer which will compare tables, columns, users, schemas, etc., but it does not seem to compare the data itself? I have a situation where the business wants to see exactly what data will be lost if any. I'm pretty desperate at this point. Thanks

    DB:3.09:Data Comparison Tool cc

    I've found a new tool that outperforms all others - it's
    Optillect Data Compare SQL.
    For our database servers it works about 6 times faster than Red-Gate and 5 times faster than Devart (which we've been using).

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Compare The Difference Of Two Files 8c


    I have two *.txt file, which are pretty similar. I wanna compare the difference of the two, how can I do that? Thanks.

    DB:3.09:How To Compare The Difference Of Two Files 8c

    Hi,

    I use a very nice freeware file compare utility found at

    http://www.geherbert.de

  • RELEVANCY SCORE 3.08

    DB:3.08:Compare Columns In Two Spreadsheets 31


    I have two spreadsheets the have the same key field in each one. The data is missing from one of the spreadsheets and I need to compare sheet 1 (that should have all the data I need) to sheet 2 (missing data) and produce a report in sheet 3 of the missing
    data

    DB:3.08:Compare Columns In Two Spreadsheets 31

    We need a bit more information before anyone can create a solution for you.

    Howis your data layout in the two sheets, and are you using same layout?

    Where should we look for missing data - in the key field column, or in all columns?

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Compare Two Blob Columns sx



    Hi,

    I have a requirement that we need to load data BLOB,LONG RAW columns from source table to target table from different DB's.Here i need to compare source blob column against target blob to get to know any change is happend or both identical.Please post your valuable suggestions.

    Regards,

    Madhu.

    DB:3.08:How To Compare Two Blob Columns sx


    Hi,

    use this in the query override in select:

    Use DBMS_LOB.SUBSTR(Column_name,250,1)

    Links where I found it:

    http://informatica-exp.blogspot.in/2011/02/if-value-is-in-mb-or-clob-data-type.html

    http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/loading-blobbinary-data-into-informatica-4384142

    You can also search i nthe Infa-Community for sample mapping. I am sure you will find an example.

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Compare Table Data Available In Two Different Databases c7


    Hi,

    I need to compare two tables data in available in two databases - how easly I can do that .. I have Table A in Database A and Table A in Database B which is snapshot of DB A.TableA - but here are some discrepencies now I need to match two tables .. but no extra space available, so no exp imp.

    Thanks in advance,
    Chitrasen

    DB:3.08:How To Compare Table Data Available In Two Different Databases c7

    HI,

    What is the difference that you are looking for, if it si for some records missing in some tables you could use MINUS and get the output. IF you are looking to compare the TABLE structure then you could look into the datadictionary VIEWS of both the database's and check the difference.

    Thanks

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Compare Two Table Schema pk


     
    Dear All,
     
    I want to compare two table schemas; I just want to send two table names like TableA, TableB.
    Now i have to check every column of tableA to column of TableB and Datatypes also.
    If both table all columns and data types are same. I want to return true otherwise False.

     
    Thanks in Advance.
     

    DB:3.07:How To Compare Two Table Schema pk

    Hi,
     
    Check the -strict option to do a strict comparison of source and destination schema
     
    HTH,
    Suprotim Agarwal
     

  • RELEVANCY SCORE 3.07

    DB:3.07:Comparing Means For Implicit Data In Jmp m3



    Hi all,

    I have a data table with columns showing frequency of events (in my case skiing accidents in different regions in the united states). The first column contains the region names. I want to compare means of Males and Females (Males and Females are another two columns in the data table) who had skiing accidents irrespective of region. I know FIT Y by X can do this, but I don't have a Y as all the numbers I have represents the number of cases. Is there a way I can compare means between Males and Females?

    Thanks in advance.

    Mike

    DB:3.07:Comparing Means For Implicit Data In Jmp m3


    Jeff,

    Thanks for the input. I was not aware of such a powerful and robust command !

    Mike

    Reeza,

    Thanks for the input. Agree, the data must be normalized to a characteristic quantity to get a sensible prediction. thanks.

    Mike

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Compare Between Two Tables With Vb.Net mx


    hello all,
    i have a database (sql server) which contains table with following data :
    two columns full name phone numbers and 1000 records on them

    the problem here i have a excel sheet with name and phone also which contains 500 record
    so i need to compare the new data with the old data and display the duplicated values before upload them to database
    ( as my be a phone number have name in new data different from old data and vice verse)
    i need to make a tool in vb.net to do it.

    Help please

    DB:3.07:How To Compare Between Two Tables With Vb.Net mx

    Hi,
    For this new issue, please reopen a new question, it will help us to create more efficient communication:)
    Thanks for your understanding.
    Best regards,
    FranklinWe are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

    Click
    HERE to participate the survey.

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Compare Data Of Xml Types In Oracle 10g 18


    Hi,

    I need to write a subprogram where i have to compare data of two xml types which are stored as records.

    Can any one suggest me how i can do this.

    eg: i have a table tab1 where cols are id,data,date. where data is of xml type.

    regards
    prasad

    DB:3.07:How To Compare Data Of Xml Types In Oracle 10g 18

    You haven't mentioned your database version or given any example of the XML you are wanting to compare or even how you expect the results to be determined and presented.

    For starters though, here's how you can flatten XML into a table type structure:

    WITH t as (select XMLTYPE('
    RECSET
    REC
    COUNTRY1/COUNTRY
    POINT1800/POINT
    USER_INFO
    USER_ID1/USER_ID
    TARGET28/TARGET
    STATE6/STATE
    TASK12/TASK
    /USER_INFO
    USER_INFO
    USER_ID5/USER_ID
    TARGET19/TARGET
    STATE1/STATE
    TASK90/TASK
    /USER_INFO
    /REC
    REC
    COUNTRY2/COUNTRY
    POINT2400/POINT
    USER_INFO
    USER_ID3/USER_ID
    TARGET14/TARGET
    STATE7/STATE
    TASK5/TASK
    /USER_INFO
    /REC
    /RECSET') as xml from dual)
    -- END OF TEST DATA
    select x.country, x.point, y.user_id, y.target, y.state, y.task
    from t
    ,XMLTABLE('/RECSET/REC'
    PASSING t.xml
    COLUMNS country NUMBER PATH '/REC/COUNTRY'
    ,point NUMBER PATH '/REC/POINT'
    ,user_info XMLTYPE PATH '/REC/*'
    ) x
    ,XMLTABLE('/USER_INFO'
    PASSING x.user_info
    COLUMNS user_id NUMBER PATH '/USER_INFO/USER_ID'
    ,target NUMBER PATH '/USER_INFO/TARGET'
    ,state NUMBER PATH '/USER_INFO/STATE'
    ,task NUMBER PATH '/USER_INFO/TASK'
    ) y

    COUNTRY POINT USER_ID TARGET STATE TASK
    ---------- ---------- ---------- ---------- ---------- ----------
    1 1800 1 28 6 12
    1 1800 5 19 1 90
    2 2400 3 14 7 5which would then allow you to carry out a table type comparison of the records.

  • RELEVANCY SCORE 3.06

    DB:3.06:Compare Data In Ssis 17


    I have data from two sources that I want to take two of the columns, compare the values and if there is a difference record that value - what's the best solution for such?

    DB:3.06:Compare Data In Ssis 17

    I think that people may have misconstrued your question. Are you asking how you would get the difference, as in the equation of A - B? If so, you can do that through a derived column transformation by simply entering the correct formula.
    For example, something like the following:
    (ISNULL(ColA) ? 0 : ColA) - (ISNULL(ColB) ? 0 : ColB)
    OR if the columns don't allow nulls:
    ColA - ColB

    Of course, you would have had to have tied the two records together in some fashion, more than likely through a business key of some sort using a lookup transformation or merge join.

    Hope this helps.Please mark answered posts. Thanks for your time.

  • RELEVANCY SCORE 3.06

    DB:3.06:How To Compare Skeleton Data In Sdk? k1


    Dear All,
    I want to compare two skeleton data in SDK using C#. How can I do that?
    For example I want to compare current handright position and position after 1 sec.
    Please help.
    Eagerly waiting for reply.
    Regards,
    Samarth.

    DB:3.06:How To Compare Skeleton Data In Sdk? k1

    Are you using the event callback model or pull mode? If you are using the event model you could try something like this:
    // local variables:
    timer;
    checkState; // possible states save, wait, compare

    void SomeInitializeFunction()
    ...
    setup timer with 1 second interval
    checkState = save
    ...

    callback Tick() function
    checkState = compare
    timeout.Stop

    // inside callback
    KinectCallbackFunction()
    ...
    if (checkState == wait)
    {
    // do nothing
    return;
    }
    else if (checkState == save)
    {
    // set the new flag
    checkState = wait;
    timer.Start
    // save data for later
    }
    else if (checkState == compare)
    {
    // compare the data
    checkState = save; //next time around grab a new frame
    }
    ...
    }

  • RELEVANCY SCORE 3.06

    DB:3.06:Excluding Certain Column Of A Table In Data Compare af


    Hello,
    How do I exclude certain columns of a table during data compare?

    My requirement is to compare the previous version of data to current version, and generate delta data script using data compare.
    In this process, I do not want the data compare utility to also compare the audit columns such as when the record was created/updated (Date time column).
    For example, while comparing lookup tables, I only want to know ifany column value except audit columns were updated.
    Is there a way to do this in Data compare?
    Thanks!


    DB:3.06:Excluding Certain Column Of A Table In Data Compare af

    Hello Anonynous 082010,
    Yes, it is possible for you to exclude certain colums in data comparsion. On the New Data Comparsion wizard, you can select the columns in the table you would like to do the data comparsion. And for these columnsyou do not want to do data comparsion,
    please just do not select these columns.
    Please refer to this screen shot for further information:

    Thanks.Vicky Song [MSFT]
    MSDN Community Support | Feedback to us

  • RELEVANCY SCORE 3.06

    DB:3.06:Compare Long Columns as


    Hi,
    How to compare two LONG columns ?
    Is there a standard methode ?

    Nicolas.

    DB:3.06:Compare Long Columns as

    Hi,

    I found myself a solution :
    Create table to migrate long to clob
    after what, I can use package dbms_lob.compare

    Nicolas.

  • RELEVANCY SCORE 3.05

    DB:3.05:How To Select Columns Of Different Criteria From Same Table a9


    Hi all,
    I've got a table with a lot of information and I want to return data that is of a user determined year in one column and data of another year in a different column so I can compare them. Unfortunately I'm having trouble doing this - any WHERE statements
    are applied on the whole query.
    For example, I want to compare the data from 2012 to the data from 2013. Is it possible to do this?

    DB:3.05:How To Select Columns Of Different Criteria From Same Table a9

    Success! I got it to work (for now haha).
    Thanks for all the help guys, you're the best!

  • RELEVANCY SCORE 3.04

    DB:3.04:Compare Two Ranges And List The Differences dc


    Hi,
    I have 2 ranges (columns) of data and I would like to compare and list the differences using just formulas:
    Col A Col B
    A A
    B C
    BC
    DE
    F F
    I want to compare and list all the unique values in Col A and append the unique but new values in Col B. So the result would be:
    A
    B
    D
    F
    C
    E
    Please advise how would I accomplish this using just formulas in Excel. Thanks!

    DB:3.04:Compare Two Ranges And List The Differences dc

    Hi,
    Using formulars only would be too complicated. If VBA is allowed you can make up something like

    the following:
    (in a codemodule of your worksheet)
    Option Explicit

    Const strColumn1 As String = A
    Const strColumn2 As String = B
    Const strColumn3 As String = I

    Sub UniqueValues()

    Dim rng As Range
    Dim lngR1 As Long
    Dim lngR2 As Long

    Set rng = ActiveCell

    lngR1 = Me.Range(strColumn1 1).End(xlDown).Row
    Me.Range(strColumn1 1: strColumn1 lngR1).Copy
    Me.Range(strColumn3 1).PasteSpecial xlPasteAll

    lngR2 = Me.Range(strColumn2 1).End(xlDown).Row
    Me.Range(strColumn2 1: strColumn2 lngR2).Copy
    Me.Range(strColumn3 lngR1 1).PasteSpecial xlPasteAll

    Me.Range(strColumn3 1: strColumn3 lngR1 lngR2).RemoveDuplicates Columns:=1, Header:=xlNo
    rng.Activate

    End Sub

    To download a test sample click
    here

    Sergiy Vakshul

  • RELEVANCY SCORE 3.04

    DB:3.04:Read And Write In The Same Excel File 9d



    Hi.

    Possible to read from the two column and write data to the next column using the same excel file? I need to compare the data as below with the other two columns of data and output in the same file. How should i do this?

    Regards,

    Ander










    Attachments:







    Example.jpg ‏1638 KB

    DB:3.04:Read And Write In The Same Excel File 9d

    That is a security warning from Excel, likely caused by the Agilent PSA/ESA software that you have installed. It's basically telling you that there's an ActiveX control installed and warning you in case you didn't know about it. This has nothing to do with LabVIEW. I do not know if the Agilent PSA/ESA software can be marked as "safe" so that Excel will not give you a warning. Assuming this is being caused by that, then Agilent is the best place to ask this question. Alternatively, you can install third-party software that is used to automatically click the "Yes" button in certain cases. There are a number of these. Don't know if it will work here, though since that software was designed to work with the security warning you get when you try to send mail using the Outlook object model.

  • RELEVANCY SCORE 3.04

    DB:3.04:How Do I Compare 2 Columns In The Same Row For An Approximate Match 9m


    Hi,

    DB:3.04:How Do I Compare 2 Columns In The Same Row For An Approximate Match 9m

    I finally have something that might work for you. The screen capture shows entries and results from this process, so you can judge some from that. Notice that it guessed wrong on row 7.

    This is done with a User Defined Function (UDF) that can be used just like a regular Excel function in a formula. It just needs the cell addresses of the two phrases to be compared. For example, in C2, the formula is

    =ApproximateEquivalence(A2,B2)
    So your two columns don't always have to be A and B, and the result can go into any available column. I think as long as a human is making the final judgment call on this, it may work for you.

    To put the code to use: Open your workbook. Press [Alt]+[F11] to open the Visual Basic Editor (VBE). In the VBE, choose
    Insert -- Module and then copy the code below and paste it into the module presented to you. Be sure and save the workbook as type .xlsm (macro enabled). Give it a trial run!

    Here is the code:

    Function ApproximateEquivalence(entry1 As Range, entry2 As Range) As Integer
    Const removeList = ".,-_;|\/?!" ' characters to remove and ignore

    Dim col_1_WorkingData As String
    Dim gp1 As Variant
    Dim gp1_Value As Long

    Dim col_2_WorkingData As String
    Dim gp2 As Variant
    Dim gp2_Value As Long

    Dim rmvLoop As Integer
    Dim LC As Integer
    Dim maxLength As Integer

    'remove leading/trailing white space make UPPERCASE
    col_1_WorkingData = UCase(Trim(entry1.Value))
    'remove punctuation
    For rmvLoop = 1 To Len(removeList)
    col_1_WorkingData = Replace(col_1_WorkingData, Mid(removeList, rmvLoop, 1), "")
    Next
    Do While InStr(col_1_WorkingData, " ") 0
    'replace 2 spaces with just one
    col_1_WorkingData = Replace(col_1_WorkingData, " ", " ")
    Loop
    'now break up the remaining phrase into 1-word groups
    gp1 = Split(col_1_WorkingData, " ")
    'find the shortest word of all
    'start by setting maxLength to value greater than any word should ever be
    maxLength = 32000
    For LC = LBound(gp1) To UBound(gp1)
    'don't use groups of less than 3 characters
    If Len(gp1(LC)) 2 And Len(gp1(LC)) maxLength Then
    maxLength = Len(gp1(LC))
    End If
    Next
    '
    'repeat the process for second column entry
    '
    col_2_WorkingData = UCase(Trim(entry2.Value))
    'remove punctuation
    For rmvLoop = 1 To Len(removeList)
    col_2_WorkingData = Replace(col_2_WorkingData, Mid(removeList, rmvLoop, 1), "")
    Next
    Do While InStr(col_2_WorkingData, " ") 0
    'replace 2 spaces with just one
    col_2_WorkingData = Replace(col_2_WorkingData, " ", " ")
    Loop
    'now break up the remaining phrase into 1-word groups
    gp2 = Split(col_2_WorkingData, " ")
    'find the shortest word of all - keeping previous value of maxLength
    For LC = LBound(gp2) To UBound(gp2)
    'don't use groups of less than 3 characters
    If Len(gp2(LC)) 2 And Len(gp2(LC)) maxLength Then
    maxLength = Len(gp2(LC))
    End If
    Next
    'now we calculate values using the shortest maxLength from both groups
    For LC = LBound(gp1) To UBound(gp1)
    gp1_Value = gp1_Value + GetWordValue(Left(gp1(LC), maxLength))
    Next
    For LC = LBound(gp2) To UBound(gp2)
    gp2_Value = gp2_Value + GetWordValue(Left(gp2(LC), maxLength))
    Next
    'test the results
    ApproximateEquivalence = 0
    If gp1_Value = gp2_Value Then
    ApproximateEquivalence = 1
    End If
    End Function
    Private Function GetWordValue(ByVal myWord As String) As Long
    On Error Resume Next
    Dim charPos As Integer
    myWord = Trim(myWord)
    For charPos = 1 To Len(myWord)
    If Len(myWord) 2 Then
    GetWordValue = GetWordValue + Asc(Mid(myWord, charPos, 1))
    End If
    Next
    If Err 0 Then
    Err.Clear
    End If
    On Error GoTo 0
    End Function

  • RELEVANCY SCORE 3.04

    DB:3.04:Sql Developer File Compare Does Not Work xc


    I am using Sql Developer 1.5.1

    I want to comapre files through file comaprison utility.

    I click on the file folder, select two of the files to compare and do Compare With -- Each Other.

    I get "Compare Not Available."

    The software would compare files, i do not know what happened and now it does not compare.

    How do i rectify this?

    DB:3.04:Sql Developer File Compare Does Not Work xc

    Have you ensured that the size of the files are within the Maximum File Size specified in Tools/Preferences/Compare and Merge.

  • RELEVANCY SCORE 3.04

    DB:3.04:Comparing Fields Of A Table In Two Systems 3k



    Hi All,

    I have a requirement where in I need to get the contents of a table from a different SAP environment dynamically and then compare the field values of that table with the fields of the table in my current system. I was able to get the data using READ_RFC_TABLE function module. The output of this Function module is of type char512. But, I need to compare the data field by field. How do I compare this? How do I split the data obtained?

    For example, I have two systems A and B. I need to compare the fields F1,F2,F3 in both systems A and B and display the data. If there is any mismatch in the data in any of the fields, I should display a message saying "Conflict".

    Appreciate your help to understand how this can be implemented.

    Thanks,

    Pavan

    DB:3.04:Comparing Fields Of A Table In Two Systems 3k


    Like Thomas said,

    I'm trying the same thing as you get two tables from different systems and compare them i even have to make them equal, but studying RSCMPADJ it's a good way to start or using the transaction that this program uses that is SCMP on of it. Also the FM of SCT1 are very helpful to compare and retrieve the data, but the code and the way it does all of this it's very complex though.

  • RELEVANCY SCORE 3.04

    DB:3.04:Comparing Tables And Columns Between Two Databases 19


    Hi,
     
    I have a two databases that may be similar but are not identical.  I would like to compare the table and column names of the two databases to find out where they differ.  Are there any tools that would help me in this task?  In Oracle I would compare the meta data of the two databases in a select clause.  Can we do the same thing in MS SQL?
     
    Thanks in advance,
     
    Dave

    DB:3.04:Comparing Tables And Columns Between Two Databases 19

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23054 should get you what you are looking.

  • RELEVANCY SCORE 3.04

    DB:3.04:Dat Dude Getting Kind Of Annoying as


    I ran a schema compare against two databases. In the target database, there are going to be several columns that need to be dropped from some tables.When I try to write these updates, DD complains about the fact there may be data loss...I know!!! And I'm okay with that!How can I tell DD to ignore the data loss and just do it??? Can I turn off the hyper-sensitive validation that DD does when comparing and syncing? This really is kind of annoying...Thanks!A. M. Robinson

    DB:3.04:Dat Dude Getting Kind Of Annoying as

    For the benefit of other readers:Incremental Deployment is blocked if data loss may occur by default.  To disable this check:  Go to project properties- Deploy Tab - Edit Deployment Configuration File - Uncheck Block incremental deployment if data loss might occurThanks.

  • RELEVANCY SCORE 3.04

    DB:3.04:Compare Two Tables To Determine Which Column Data Is Different k9


    We are doing a conversion into oracle and we pulled data 1 year ago to cleanse and loadwe now pull any record that has been updated since the original extract--how can we determine which fields were updated?I have seen multiple discussion about comparing each table but I want to compare each column and indicate for the record which columns got updated since oracle tables do not show the update only that they have changed

    DB:3.04:Compare Two Tables To Determine Which Column Data Is Different k9

    Hi,Exactly how to do what you want depends on exactly what you want, as well as your data and your Oracle version. Post a little sample data (CREATE TABLE and INSERT statements) and the results you want from that data. If you're flexible about what kind of results you want, post something that you would consider ideal, and describe what parts can be changed, if necessary.Explain exactly what you need to do. For example: is there a primary key that you assume will not have changed? If rows have been DELETEd, or new rows INSERTed, do you want to show all the non-NULL columns? Include examples in your sample data and results.See the forum FAQ: https://forums.oracle.com/message/9362002You may want to Unpivot the data, so that each column you need to compare is on a separate row. You can Pivot the results back to 1 row (or 2 rows: before and after) for display purposes. This is an example of why you have to say which version you're using; Oracle added features for unpivoting and pivoting in version 11.

  • RELEVANCY SCORE 3.03

    DB:3.03:Diffing Two Strings sk


    I have a row-level trigger on a table that captures :new and :old values of columns to an audit/history table.

    Say I have 2 strings New York and Nwe Yrok in that audit table in columns c1 and c2.

    How can I "diff" the 2 columns to come up with the New York i.e. highlight the difference between the 2 strings?

    Sort of like how file compare utilities do it in SCM software.

    Thanks

    DB:3.03:Diffing Two Strings sk

    Try using MODEL.

    SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 14 03:19:13 2007

    set null "(null)"

    create table t ( key number, c1 varchar2(10), c2 varchar2(10) );

    insert into t values ( 1, 'New York', 'Nwe Yrok' );
    insert into t values ( 2, 'New York', 'New Yo' );
    insert into t values ( 3, 'New York', 'New Yorker' );
    insert into t values ( 4, 'New York', null );
    insert into t values ( 5, 'New York', 'New York' );
    insert into t values ( 6, null , 'New York' );
    insert into t values ( 7, null , null );

    commit;

    select c1, c2, diff
    from t
    model
    partition by ( key )
    dimension by ( 1 as dim )
    measures
    ( c1,
    c2,
    c1 as diff,
    length(c1) as c1_length
    )
    rules update
    iterate (1000) until ( iteration_number = c1_length[1] - 1 )
    ( diff[1] =
    case
    when c1[1] is null then null
    when substr( c1[1], iteration_number+1, 1 ) = substr( c2[1], iteration_number+1, 1 )
    then diff[1]
    else regexp_replace( diff[1], '.', '*', 1, iteration_number+1 )
    end
    )
    order by key ;

    C1 C2 DIFF
    ---------- ---------- ----------
    New York Nwe Yrok N** Y**k
    New York New Yo New Yo**
    New York New Yorker New York
    New York (null) ********
    New York New York New York
    (null) New York (null)
    (null) (null) (null)

    -- or maybe this way --

    set heading off
    set recsep each

    column diff fold_before

    select c1, c2, diff
    from t
    model
    partition by ( key )
    dimension by ( 1 as dim )
    measures
    ( c1,
    c2,
    cast( null as varchar2(10) ) as diff,
    length(c1) as c1_length
    )
    rules update
    iterate (1000) until ( iteration_number = c1_length[1] - 1 )
    ( diff[1] = diff[1] ||
    case
    when c1[1] is null then null
    when substr( c1[1], iteration_number+1, 1 ) = substr( c2[1], iteration_number+1, 1 )
    then ' '
    else '*'
    end
    )
    order by key ;

    New York Nwe Yrok
    ** **

    New York New Yo
    **

    New York New Yorker

    New York (null)
    ********

    New York New York

    (null) New York
    (null)

    (null) (null)
    (null)I used * to highlight the differing character positions, but you can substitute whatever highlighting code you require in its place.

    --
    Joe Fuda
    SQL Snippets

  • RELEVANCY SCORE 3.03

    DB:3.03:Pls Help! Compare Two Numeric Fields (Sums)--Greater Or Lesser Shows Different Image 3p



    In my PDF form: I have two columns (A and B) each with 10 fields where the user selects values of 1 through 5 for each. I have two fields at the bottom of each column: SumA and SumB. I need to be able to compare the two summed fields --SumA and SumB (which is greater/lesser, etc) and depending on which one is greater, show a particular image.

    Does anyone know how to do this?

    Any and ALL help will be greatly appreciated!

    Thanks!

    DB:3.03:Pls Help! Compare Two Numeric Fields (Sums)--Greater Or Lesser Shows Different Image 3p


    Firstly I would name all your rows (except the total) the same thing eg. Row1. Then for the total cells at the bottom you could put in formcalc in the calculate event of each total cell:

    $ = sum(Row1[*].Cell1) // or whatever the row and cells are called.

    Then you could put in the layoutReady event in formcalc:

    if (Table1.Row4.Cell1[1] Table1.Row4.Cell1[0]) then // renaming to whatever your total cells are called

    Image1.presence = "visible"

    Image2.presence = "hidden"

    elseif (Table1.Row4.Cell1[0] Table1.Row4.Cell1[1]) then

    Image1.presence = "hidden"

    Image2.presence = "visible"

    endif

  • RELEVANCY SCORE 3.03

    DB:3.03:Can You Compare Two Diferent Spreadsheets Using Macros ap


    I have two spreadsheets with the exact same amount of columns and rows and one column has identical values. I need to compare these two spreadsheets and determine the differences between the two.

    DB:3.03:Can You Compare Two Diferent Spreadsheets Using Macros ap

    A lot depends on if the columns and rows are in the same order, or if you can restore one sheet to the same order as the other. Then you could use a third sheet, with formulas like
    =IF(Sheet1!A1Sheet2!A1,"Change","")
    filling the third sheet.
    If not, then you need more sophisticated formulas.
    Bernie

  • RELEVANCY SCORE 3.02

    DB:3.02:Conditional Format A Ightswitch Screen Column sj


    Compare Two Columns of Detail Screen Side By Side To Highlight/change Color Of Difference
    Is it possible to compare two columns side by side to highlight/change color of difference between the two cells? I need to compare and show the changes to the record from previous version and highlight the changes (Let person pay attention the changed
    cell.)
    For example if the
    Column 1 (Previous Version) :The structure contains Wire, Bolt, Stmaps etc

    Column 2 (Current Version) : The structure contains Wire, Bolt, Stamps etc

    Data Changed: YES
    Any help will be much appreciated.

    DB:3.02:Conditional Format A Ightswitch Screen Column sj

    If you look at ace Lightswitch hacker Jewel's blog, you'll see she has a couple of posts about modifying grids, and I seem to remember she also has one about conditionally colouring grid rows depending on the data in
    the row. Between these two, you should find what you want.
    Hope this helps.FREE custom controls for Lightswitch! A collection of useful controls for Lightswitch developers.

    Download from the Visual Studio Gallery.
    If you're really bored, you could read about my experiments with .NET and some of Microsoft's newer technologies at
    http://dotnetwhatnot.pixata.co.uk/

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Compare Two Vbai File? xp



    How do I compare two VBAI files?

    I have 2 parallel version of a VBAI file. How can I compare their differences?

  • RELEVANCY SCORE 3.01

    DB:3.01:How To Compare Databases ms


    I have two database on two diff. server. I want to compare two database of those servers. how do i do that without 3rd party tool.

    DB:3.01:How To Compare Databases ms


    Do you need compare database data or databse schema ?
    You can use Visual Stduio Database Professionals (Data Dude).
    Data Dude provide Schema compare and Data compare.

    Hong-ju

  • RELEVANCY SCORE 3.00

    DB:3.00:How Do U Compare Two Database Schemas?? jz


    Hi ,
    i have two instances of a same application, "PRODUCTION Instance"- released to the client, "DEVELOPMENT Instance"- used for making changes,development etc... Now if i make changes to the application pages in development instance i will do a repatching of it in the Production Instance ...But the problem is it is becoming difficult to track the changes made at the "DATA BASE LEVEL" like adding columns to a table, renaming of columns etc...

    Is there a way to compare two "DATABASE SCHEMAS" and get the differences between them.....just like we get the various reports in the schema or workspace of the default "application level reports"

    regards
    Naveen

    DB:3.00:How Do U Compare Two Database Schemas?? jz

    Hi Naveen,

    There's nothing built in that will do that, you could use a third-party tool such as TOAD which (I believe) can do it, years ago I also used a tool called PowerDesigner which was extremely good at generating the scripts needed to update one schema design to another.

    You could probably create your own scripts to do this by querying user_tables, user_tab_cols etc, it depends how much time you have.

  • RELEVANCY SCORE 3.00

    DB:3.00:Comparing Two Columns dd


    Hello,I have a data set with location (address, city, state) information, as well as automated cleaned up location (cleanedaddress, cleanedcity, cleanedstate). I wanted to compare each row in a fuzzy manner to come up with a similarity score. I do not want to have each row compared to the entire index of all the data in the source table. Any suggestions on how to do this?

    DB:3.00:Comparing Two Columns dd

    Thanks Todd,I just came across the same thing online. It looks like it may work for what I need to do. Here's the T-SQL way of doing it.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51540- Vimal

  • RELEVANCY SCORE 3.00

    DB:3.00:Compare Two Table. ss


    Hello All,

    Is it possible to compare two table in oracle?

    i.e. suppose i have one table "Emp1" in scott other table "Emp2" in hr. Both table have same columns, column type data. How can i do it?

    Also, suppose if i need to transfer one table from one database to other database then only export will do it?

    DB:3.00:Compare Two Table. ss

    As Guido suggested you can use MINUS to compare the results of two tables.

    I use the the first table MINUS the second to get the rows in the first table not in the second, then the second minus the first to see if the second table has any rows not in the first. I also do a count of each to see if any rows are duplicated if that's possible.

  • RELEVANCY SCORE 3.00

    DB:3.00:How To Compare Two Records kf


    Hello,
    is there a way to compare the values of two records, except by hardcoding every column.
    We are migrating from host to ORACLE and a user has to decide what to do with a record. There are many columns and it is easier if he only sees the differences.
    I try to write a package which returns a PL/SQL Table containing only the different columns with columnname and value, yet not only for one table, but for any table

    regards
    Marcus

    DB:3.00:How To Compare Two Records kf

    We can help you better/faster if you show us the
    packageHello,
    the package does not yet exist, because I'm not sure how to begin. I can not simply pass two rowtypes of my table, because this would restrict the comparison to this table.
    I might pass the name of the table and compare every column by a loop over the columns in the sys.col view, but how do I know then which two rows to compare??

    regards
    Marcus

  • RELEVANCY SCORE 3.00

    DB:3.00:Record Comparison In A Cursor 1m


    I need to compare records between two tables in a cursor so that I can insert data into another table if the data is NOT same:
    Database: 9i

    CURSOR cur1 is select t1.*, t2.* from t1, t2 where t1.col1 = t2.col2
    FOR rec1 IN c1_cursor LOOP
    .....
    IF
    NVL(rec1.col1,'*') = NVL(rec1.col2,'*') AND
    NVL(rec1.col3,'*') = NVL(rec1.col4,'*')
    THEN NULL;
    ELSE
    INSERT INTO....
    END IF;
    END LOOP;

    The left hand side records in the cursor are from t1 table and right from t2 table. I have 1 million records to compare and 30 columns to compare, how do I increase performance. Currently it takes about 40 minutes for the cursor to go through this comparison.
    I have to use a cursor b/c there is come processing that needs to be done for columns before they are compared in the IF stmt.

    Thanks and Regards
    Swayamprakash.Chiluveru

    DB:3.00:Record Comparison In A Cursor 1m

    Please edit this thread and type it as *"duplicate post"* . And, remove the content from here.

    Regards.

    Satyaki De.

  • RELEVANCY SCORE 3.00

    DB:3.00:Mdx Group Data Based On Parameter xc


    Hi,

    i am using SSRS report and getting data from cube . i have two parameter @CustidA,@CustidB,
    in the where condition i merged this two parameter in to one parameter @custC and getting all the value .
    now the problem is i want to show the data grouped by this 2 parameter .
    i want to compare the @CustidA with my cube and make it one group same way another one also .
    with calculated member we can do it but i dont know how to compare if user enter set of more values.
    i want my final output like below any help and suggestions appreciated .
    SELECT NON EMPTY { [Data].[Tran Cnt] } ON COLUMNS,

    NON EMPTY { ([Reg].[Reg].[RegType].ALLMEMBERS ) } ON ROWS

    FROM [MYCUBE]

    WHERE

    STRTOSET(@custc, CONSTRAINED) ,

    [Month].[Month Year].[Jan 2012]

    RegType
    CNT
    CustType

    REGA
    100
    CUSTA

    REGB
    200
    CUSTA

    REGA
    300
    CUSTB

    REGC
    100
    CUSTA

    DB:3.00:Mdx Group Data Based On Parameter xc

    Hello ,
    You should be constructing your MDX as below
    SELECT NON EMPTY { [Data].[Tran Cnt] } ON COLUMNS,
    NON EMPTY ([Reg].[Reg].[RegType].ALLMEMBERS,STRTOSET('{' @CustidA ',' Custidb '}' ) ON ROWS
    FROM [MYCUBE]
    WHERE
    (
    [Month].[Month Year].[Jan 2012]
    )
    Below is the sample Adventureworks query using the STRtoSet
    SELECT
    ([Geography].[Country].[Country],STRTOSET('{[Product].[Category].[4],[Product].[Category].[1]}')) ON 1
    ,[Measures].[Sales Amount] ON 0
    FROM [Adventure Works]
    Best Regards Sorna

  • RELEVANCY SCORE 3.00

    DB:3.00:How Do I Compare Multiple Columns j9


    Hi,

    I want to compare a list with two columns to another list with two columns and find duplicates.

    For example,

    a
    b
    c
    d
    e
    f

    id
    name

    id
    name
    results

    123
    smith

    456
    smith
    no

    456
    jones

    987
    smith
    yes

    789
    jones

    123
    smith
    yes

    987
    smith

    132
    chen
    no

    654
    chen

    321
    chen

    I want to compare columns d and e to columns a and b and show either a yes or no in column f.

    Thanks

    DB:3.00:How Do I Compare Multiple Columns j9

    awesome. works great. thank you very much.

  • RELEVANCY SCORE 3.00

    DB:3.00:Key Figure Comparison For Two Time Periods da



    Hi SAP Gurus,

    Iam a novice in BI 7.0. I currently need some advice and directions on the following situation.

    The datawarehousing holds data based on calendar dates. The BI system extracts the data from an MS SQL Server.

    The report needs to compare key figures for two time periods. The time period may either be Monthly/Quarterly/Yearly or for that case can be a date range also. The key figures has to be displayed in two columns and only two columns (one each for the time periods).

    Kindly do advice me on how to model and design the report based on the time-period and restricting it to only two columns.

    I would much appreciate all kinds of suggestions.

    Thanks,

    Arun.

    DB:3.00:Key Figure Comparison For Two Time Periods da


    Dear Olivier,

    Trust Ur doing fine. Thnx for the support and help. I created a separate variable and solved the issue.

    Sorry for the belated reply, I was on travel.

    Regards,

    Arun.

  • RELEVANCY SCORE 3.00

    DB:3.00:How Can I Compare Records From Same Dataset k1



    I want to compare shopping habits of two customers. A simple data sample data is laid-out

    MonthCustomerIdProduct CategorySub CategoryAmount SpendJan1EntertainmentMusic50Jan1EntertainmentGames50Jan1ElectronicsMobile500Jan1ElectronicsHome200Jan1BooksAudio50Jan1EntertainmentMusic20Feb2EntertainmentMusic20Jan2ElectronicsHome300Jan2BooksAudio50Jan2BooksHard Copy20Jan2EntertainmentMusic20Feb2BooksHard Copy100Feb2EntertainmentGames100Jan3EntertainmentMusic150Feb3EntertainmentGames10

    And I want to create a view where I can compare two customers (for a period of time). The view would look something like

    Thanks

  • RELEVANCY SCORE 3.00

    DB:3.00:Compare Distribution Of Same Variable Over Two Data Pulls / Time dk



    Hi all,

    I want to compare the same variable distribution over two data pulls or over time.

    What I want to see if the distribution has changed over time statistically. Can i get KS stats for the variable.

    How would i do it.

    I appreciate all your help.

    Regards,

    Amit

    DB:3.00:Compare Distribution Of Same Variable Over Two Data Pulls / Time dk


    You can get the tests that you want with npar1way like this :

    data test;do time = 10, 11; do i = 1 to 25; x = rand("NORMAL", time, 1); output; end; end;run;

    proc npar1way data=test edf;class time;var x;run;

    PG

  • RELEVANCY SCORE 2.99

    DB:2.99:Proc Compare sz



    i am comparing two sas data set A and B. like

    proc compare base = lib.A compare = lib.B out=lib.c;

    quit;

    On running this proc step in C data set i get all columns name.

    i don't want this.

    i want to store the name of those columns whose value is not equal, in data set C.

    DB:2.99:Proc Compare sz


    You will want to review the SAS PROC COMPARE options. The SAS support website http://support.sas.com/ has a wealth of technical papers and SAS-hosted documentation on this topic.

    Scott Barry

    SBBWorks, Inc.

    SAS PROC COMPARE documentation:

    http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000057814.htm

  • RELEVANCY SCORE 2.99

    DB:2.99:Comparing The Data Of 2 Fileds xk



    Hi

    i have two fileds f1 and f2 in an internal table.i want to compare the data in these two fileds ,

    how to compare?

    thank you.

    sunny.

  • RELEVANCY SCORE 2.99

    DB:2.99:How To Compare 2 Columns With Data Like... 1m


    Hi,
    I have to compare 2 columns from 2 different tables the columns contain data like

    SELECT CIRCLE FROM RATE_PLAN

    OUTPUT
    (AP,NAT)
    (AS,NAT)
    (BH,NAT).

    SELECT CIRCLE FROM subscriber_info
    (AP,NAT)
    (AS,NAT)
    (BH,NAT)

    but when i put a join on the tables on this column i get the ouput as -0 rows returned

    select col1,col2 from rate_plan,subscriber_info
    where
    rate_plan.CIRCLE=subscriber_info.CIRCLE

    HOW DO I COMPARE THE 2 COLUMNS SO THAT I GET MATCHING RECORDS??

    NOTE:-DATATYPE OF BOTH THE COLUMNS IS SAME.

    DB:2.99:How To Compare 2 Columns With Data Like... 1m

    Hi,
    using SQL*Plus can you cut and paste the result of following commands :set tab off
    set trimout on
    set trimspool on
    desc rate_plan;
    SELECT '-'||CIRCLE||'-' c FROM RATE_PLAN ;
    desc subscriber_info;
    SELECT '-'||CIRCLE||'-' c FROM subscriber_info ;And be sure to use the tags {noformat}{noformat} before and after the pasted output.

  • RELEVANCY SCORE 2.99

    DB:2.99:Finding Same Data Columns 9m


    There was missing one html file that was forwarded as a thanks after posting the data. So operator has inserted duplicate data many times to the DB. There is no check of uniqueness on any column as the nature of data is like this.

    Please let me know how can I compare and find the similar two columns value i.e. term and definition

    Thanks best regards

    DB:2.99:Finding Same Data Columns 9m

    not sure if this will help.

    select term, definition
    from [table]
    group by term, definition
    having count(*) 1