• RELEVANCY SCORE 3.63

    DB:3.63:Join Two Fields In Same Table f3




    I have two fields in same table I want to put two fields values in one column

    DB:3.63:Join Two Fields In Same Table f3


    Hi,

    U can write a script like,

    Load *

    ,UniteAdiG1'#'UniteAdiG2 as NewField

    From SomeTable;

    Regards,

    Kabilan K

  • RELEVANCY SCORE 3.61

    DB:3.61:Populating Data Of A No Qualifier Field a7





    Hi All,

    I have 3-4 fields as Yes Qualifiers in my Qualified Table. I want to merge the data of these fields into a single No Qualifier field of the same table so that I can see that data in Matching Mode while merging of two records as I can not see the data of Yes qualifiers in matching mode.

    DB:3.61:Populating Data Of A No Qualifier Field a7


    hi,

    1. in the console, in the qualified table, create one ( NO qualifier multivalued) filed.

    2. When you are importing qualified table, use partitions to concatenate required YES qualifiers, it will create one concatenated multivalued field. Those concatenated fields separated by delimeters.

    3. Map source multivalued field to the Destination No qualifier multivalued field.

    4.Do the import, and you can see the concatenated fields in the match mode, when ever you are doing merging of two records.

    hope this may help you,

    Regards

    Srinivas

  • RELEVANCY SCORE 3.33

    DB:3.33:Matching Data That Does Not Match Entirely z9





    I want to create a report where I reflect the details from Table 1 Table 2. I have two tables that reflect the same data but with a slight variation. In the Table 1, the persons name appears as first name, and surname as individual fields. In Table 2, the same person will appear as the the first name and surname combined however limited to 29 or 30 characters. How would I match the data correctly or link it together so that the same person may exist as one record in a report.

    Example:

    Table 1

    First name: Barry Roland James Porter Ta

    Surname: Anastasia

    Table 2:

    Agent: Barry Roland James Porter Ta A

    DB:3.33:Matching Data That Does Not Match Entirely z9


    Hi,

    Create another field in you Table 1 which has Firstname and surname Concatenated and upto 25 or 30 (depending on the size of your Agent Field)characters. Eg:

    Tab1:

    Load

    First Name,

    Surname,

    Left(FirstnameSurname,25) as Agent

    Tab2:

    Load

    Agent

  • RELEVANCY SCORE 3.32

    DB:3.32:Smartform Trouble j1



    I have to display two fields from different tables in same text-element.Date of order and delivery date.

    How can I display both the fields using loop such that only matching records are stored in the itab

    DB:3.32:Smartform Trouble j1


    Hi Musarrat

    you can define a strucutre in se11 and can define your internal table of type that zstrucutre or else

    you can define types statements in the types tab under the global definitions node this way.

    Eg:

    TYPES : BEGIN OF TY_MARA

    MATNR LIKE MARA-MATNR,

    WERKS LIKE MARC-WERKS,

    END OF TY_MARA.

    Now under the tables Tab in global definitions define your int table it_mara of bTYPE REF TO/b ty_mara

    in the initialization tab you can write your select queries to get data in the int table.

    hope it is clear

    Plz reward points if helpful.

    Regards

    Zarina

  • RELEVANCY SCORE 3.30

    DB:3.30:Rg1 Table - Cin ( Table - J_2irg1bal ) x1



    Dear All,

    Can you please inform me meaning of 2 fields in the table J_2IRG1BAL?

    OP_CF OP_FINISH

    From the name, it appears both are opening stocks in qunatity. If it is so, what is the difference between these two? The Data populated for these 2 fields is also different.

    I am sure SAP would not provide 2 fields for the same purpose.

    Regards

    Nikhil

    DB:3.30:Rg1 Table - Cin ( Table - J_2irg1bal ) x1


    Dear Nikhil

    OP_CF is means by Opening Carrie forward

    It shows Opening stock Carrie forwarded of material

    OP-FINISH is meaning opening of Finish product

    It show Opening stock of material

    Hope it will help u.

    Regards

    Happy Surana

  • RELEVANCY SCORE 3.23

    DB:3.23:Deleting Record From Previous Table During Load 3m



    HI All,

    I have several hundred files to load all with the exact same fields. I am currently using:

    NMDS:

    Load*

    FROM

    [..\..\8.Import\0.NMDS\2013\*.txt]

    (txt, codepage is 1252, no labels, delimiter is ',', msq);

    One requirement is to look for 'D1' records in the 'Message' Field. If it finds a 'D1' record then i need to search the records i have loaded so far for the matching Primary Key and Delete (or Flag) the matching record that has previously been loaded. Any suggestions on how this could be achieved?

    Kind regards,

    Daniel

    DB:3.23:Deleting Record From Previous Table During Load 3m


    Hi Rob,

    No you are not being naive and have produced a fantastic solution. I think i was over complicating this!! Your solution works based on the sample provided and I will test on the full data in the next day or two.

    The delete may not always be followed by a new insert however if it is not then the delete record would be the one left and these will be excluded anyway. The only thing I need to ensure is they are ordered 'D1' then 'A1' as the records are loaded from each file.

    Thanks for your help and enjoy the week ahead.

    Dan

  • RELEVANCY SCORE 3.19

    DB:3.19:Update One Table With Values From Another 7s


    I have two identical tables with 4 columns and100 records in each. Both table have a matching field DrawingNumber. One table has all four fields populated with data .The other only has the DrawingNumber column populated.
    I want to pupulatethis tables empty columnswith the values from the other table.
    The following statement pulls in the target records
    use admGo_TestDB
    SELECT DrawingNumber,Partname,Description,ECN
    FROM dbo.admGO_Target

    WHERE EXISTS
    (SELECT *
    FROM dbo.admGO_Source
    WHERE dbo.admGO_Source.DrawingNumber = dbo.admGO_Target.DrawingNumber)
    How do I perform an UPDATE version of the above?
    Thanks

    DB:3.19:Update One Table With Values From Another 7s

    Hi Naomi
    When i run the Select version ,100 records are returned ,So the target files are selected.
    123456 NULLNULLNULL
    222222 NULLNULLNULL
    555555 NULLNULLNULL
    666666 NULLNULLNULL
    etc etc
    Now when I run the Update version ,I get the message 100 records affected ,so I assume all the NULL's have been filled in.
    So I run a Select statement and the table hasn't changed?

    /*Select version*/

    SELECT S.Partname as SourcePartName, Target.Partname,
    S.ECN AS SourceECN, Target.ECN,
    S.Description AS SourceDescription, Target.Description

    FROM dbo.admGO_Source S

    INNER JOIN dbo.admGO_Target Target

    ON S.DrawingNumber = Target.DrawingNumber

    /*Update version*/

    UPDATE S

    SET Partname = Target.Partname ,
    ECN=Target.ECN,
    Description = Target.Description

    FROM dbo.admGO_Source S

    INNER JOIN dbo.admGO_Target Target

    ON S.DrawingNumber = Target.DrawingNumber

    /*Results*/

    SELECT * FROM dbo.admGO_Source

  • RELEVANCY SCORE 3.16

    DB:3.16:Best Way To Clear Page Data Explicitly As Ppr Event f8


    Hi Folks,I have an OA Page, with search LOV field, result table when performed searched, and an other LOV. Two buttons, to perform search, and to clear data in page.I need to clear data in page, when clicked on clear button. This functionality I need to perform as PPR event, so that, page do not get refresh.1.For clearing results table, I am firing the same VO with wrong matching parameters, so that VO do not fetch any records , thus table will not display records in UI.Is this approach correct? Is there, any better approach to achieve this functionality.2.How to clear other two LOV fields ?Thanks,Naresh

    DB:3.16:Best Way To Clear Page Data Explicitly As Ppr Event f8

    HiI got the solution.Blanking out page fields using -- mlov.setValue(oapagecontext,""); or mlov.setValue(oapagecontext,null); -- will not work.Have a Dummy VO, with a blank record, and point this VO row to field values.Initalize and clear VO, when ever necessary.It worked for me.Thanks.

  • RELEVANCY SCORE 3.15

    DB:3.15:Updation Of Db Table From Table. 1d



    Hi ,

    My requirements is I need to update the DB table and during updation only two fields are to be changed based on a condition, Rest of all the fields shud remain same. I passed the fields ( that are to be changed) using the work areas( Modify table) . but then whn i check in DB table a new record is getting created with just two fields that were passed and old record still exists and is not updated. Could you please tell me as how to create a updated row containing the old values + the fields that are updated.

    Thanks

    DB:3.15:Updation Of Db Table From Table. 1d


    Hi,

    You can use update statement.

    UPDATE tablename SET fieldname = value

    WHERE based on the conditions.

    If you are using Modify

    if record doesnt exist it will be inserted on the basis of KEY

    if esixts then it will be modified.on the basis of KEY

    i.e. insert+update.

    a

  • RELEVANCY SCORE 3.15

    DB:3.15:Data Lookup Amp; Record Matching Question ck



    Hi, has anybody investigated the newly released Data lookup record matching feature in Berlin release? I have looking whether it is better suited to replace our current Assignment rules. However what I found is that if you want to define a Data lookup definition - Matcher/Setter field definition, you can specify only fields on the source table, not any fields on tables that are referenced by the source table.Example: our current Assignment rule is based on the Caller.location, i.e. the location field is a field on the referenced sys_user table on the Incident table, but not on Incident table directly.It appears not possible to achieve the same thing using a Data lookup table, since we can select only Incident fields in the Matcher field definition.Any idea whether I have missed something here, or is there a way to be more flexible on the condition definitions?BRShuguang

    DB:3.15:Data Lookup Amp; Record Matching Question ck


    Hi, has anybody investigated the newly released Data lookup record matching feature in Berlin release? I have looking whether it is better suited to replace our current Assignment rules. However what I found is that if you want to define a Data lookup definition - Matcher/Setter field definition, you can specify only fields on the source table, not any fields on tables that are referenced by the source table.Example: our current Assignment rule is based on the Caller.location, i.e. the location field is a field on the referenced sys_user table on the Incident table, but not on Incident table directly.It appears not possible to achieve the same thing using a Data lookup table, since we can select only Incident fields in the Matcher field definition.Any idea whether I have missed something here, or is there a way to be more flexible on the condition definitions?BRShuguang

  • RELEVANCY SCORE 3.12

    DB:3.12:Re: Two Fields Matching. c8


    AFAIK.. No...
    But Frank/John might help you..

  • RELEVANCY SCORE 3.12

    DB:3.12:Comparing Two Internal Tables 1s



    hi all,

    i have to compare two internal tables based on 3 fields and if the lineitems with those fields are matching , i have to delete that line item from the first internal table.

    DB:3.12:Comparing Two Internal Tables 1s


    Hi Santosh.

    The following code is working and will meet ur purpose.

    TYPES: BEGIN OF T_ITAB1,

    FLD1(5) TYPE C,

    FLD2(5) TYPE C,

    FLD3(5) TYPE C,

    END OF T_ITAB1.

    TYPES: BEGIN OF T_ITAB2,

    FLD1(5) TYPE C,

    FLD2(5) TYPE C,

    FLD3(5) TYPE C,

    END OF T_ITAB2.

    DATA: ITAB1 TYPE STANDARD TABLE OF T_ITAB1,

    ITAB2 TYPE STANDARD TABLE OF T_ITAB2,

    WA_ITAB1 LIKE LINE OF ITAB1,

    WA_ITAB2 LIKE LINE OF ITAB2.

    WA_ITAB1-FLD1 = 'AAAA'.

    WA_ITAB1-FLD2 = '1111'.

    WA_ITAB1-FLD3 = '2222'.

    APPEND WA_ITAB1 TO ITAB1.

    CLEAR WA_ITAB1.

    WA_ITAB1-FLD1 = 'BBBB'.

    WA_ITAB1-FLD2 = '6666'.

    WA_ITAB1-FLD3 = '7777'.

    APPEND WA_ITAB1 TO ITAB1.

    CLEAR WA_ITAB1.

    *********************************

    WA_ITAB2-FLD1 = 'AAAA'.

    WA_ITAB2-FLD2 = '1111'.

    WA_ITAB2-FLD3 = '2222'.

    APPEND WA_ITAB2 TO ITAB2.

    CLEAR WA_ITAB2.

    WA_ITAB2-FLD1 = 'CCCC'.

    WA_ITAB2-FLD2 = '8888'.

    WA_ITAB2-FLD3 = '9999'.

    APPEND WA_ITAB2 TO ITAB2.

    CLEAR WA_ITAB2.

    *************************************

    LOOP AT ITAB1 INTO WA_ITAB1.

    LOOP AT ITAB2 INTO WA_ITAB2.

    IF WA_ITAB2-FLD1 = WA_ITAB1-FLD1 AND WA_ITAB2-FLD2 = WA_ITAB1-FLD2.

    DELETE ITAB1.

    ENDIF.

    ENDLOOP.

    ENDLOOP.

    Thanks and Regards

    Suraj S Nair

  • RELEVANCY SCORE 3.11

    DB:3.11:Lookup . 9m



    if I have one table with a set of values, how can I import lookuo a related set of values based on two fields matching, wether a value is imported once or many times would depend on the first field matching surely I can do this ?

    Currently if the lookup table has a value that matches the result is only shown or imported into the first matching record of the second database table.... thanks...

    DB:3.11:Lookup . 9m


    You can run a backup (before risking a Replace Field Contents process), and then.

    Find all records. Go to the field which needs cleaning (one field at a time if there are multiple fields).

    Do a Replace Field Contents... (lower part of Records pull-down menu) using the lower choice: Replace with Calculated Result:
    Trim ( fieldname )
    That should remove all leading and training spaces around the actual data. If there are Returns/Para in some records, you may also want to run a replace using the Substitute function as a separate step, substituting "" for the return character.

    And, if you do it wrong, you have the backup. There is NO UNDO for the replace process. Back up first in case...

  • RELEVANCY SCORE 3.09

    DB:3.09:Dqs Matching - Writing Matched Records To Existing Table With Data? dx


    I matched output from one DQS Matching taskto dbo.MatchedRecords.
    At a later subsequent step in SSIS I also write output from another DS Matching task to the same table.
    I was concerned that there would be a clash when the second DQS Matching task tried to write to the my table dbo.MatchedRecords with the same RecordId?
    Ihad no issue and the second DQS Matching task uses generates different RecordId's.
    How does DQS Matching do this- does DQS Matching check the Record Id's in the existing table?

    CG

    DB:3.09:Dqs Matching - Writing Matched Records To Existing Table With Data? dx

    Inspect the RecordID values in the DataViewer.

    I do not know what is your setup. Images, examples would be good.
    I suspect you just need a test that targets the duplication Arthur

    MyBlog

    Twitter

  • RELEVANCY SCORE 3.08

    DB:3.08:Transfer Append-Fields To Eewb x3



    Hi all,

    I've a big problem.

    In CRM 4.0 another developer appended two fields directly to table BUT051 instead of using the EEWB.

    Now we made an upgrade to CRM 2007 and of course both fields aren't available in WebUI and BOL.

    Is there any possibility to transfer these two fields into an EEWB-enhancement with the same name, so that we don't lose data on database?

    Thanks

    Martin

    DB:3.08:Transfer Append-Fields To Eewb x3


    Hi Vijay

    Thanks for your answer, I suspected that, cause in this case we have to choose between the work of implemention for WebUI or for SAP-GUI, which is already in use further on.

    Martin

  • RELEVANCY SCORE 3.07

    DB:3.07:How To Check Two Fields Are Matching In A Validator? aj


    I have a "Password" field and a "Conform password" field. I like to check whether these two fields are matching in the password_validate(FacesContext context, UIComponent component, Object value) method. How to do that?

    Thanks.

    DB:3.07:How To Check Two Fields Are Matching In A Validator? aj

    Thanks very much Jetsons !

    As you have mentioned, we are able to get one field's value in another field's validator method, we can easily compare them.

    But I remember this was not possible in the earlier versions of Creator.

    Anyway this is working now, and the tasks like checking "password" and "conform psaaword" fields have become easy.

    Thanks.

  • RELEVANCY SCORE 3.06

    DB:3.06:Ekpo Table sm


    All,In EKPO we can see two fields MATNR and EMATN , but in both I can see same material number .Can anyone please tell me what is the relevance of these two fields?Thanks

    DB:3.06:Ekpo Table sm

    HiIn PO screen, in line item section , the "IM Material" (Inventory Managed Material) field holds the data for EKPO - MATNR.ThanksE.Avudaiappan

  • RELEVANCY SCORE 3.05

    DB:3.05:Portable Insert dm


    Hi
    I have two tables which get fields added over time as they are accessed by several apps for various reasons. Is there a portable way to insert rows from one to the other in a way that fields with matching names get data inserted and rest of fields in either
    table are ignored? This is to avoid changing code in my app every time fields are added to any of the tables by another user.
    Many Thanks
    Regards

    DB:3.05:Portable Insert dm

    Yahya ,
    As far as i know there is no straight forward thing for it unless you go for some third party Solutions like AlfaAlfa,SQL Delta and SQL Server Comparison Expertfor DB schema
    comparisons.
    i have used SQL Delta and it has good support for it.
    whereashere isaSQL script (in SQL Server 2008) that will compare one table with another and if found same matching column as you said ignoring the mismatches,
    it will return you a query that you can execute to Synchronise data. i had two tables
    'tblPrice' and 'tblPriceNew' with some similar column names.

    Declare @MachingColumnList varchar(1000)
    declare @result varchar(100)
    DECLARE @COLUMN_NAME nvarchar(250), @DATA_TYPE nvarchar(250)

    set @MachingColumnList =
    DECLARE country_cursor CURSOR FOR
    select COLUMN_NAME , DATA_TYPE from INFORMATION_SCHEMA.COLUMNS
    where TABLE_NAME = tblPrice order by ORDINAL_POSITION

    OPEN country_cursor;

    FETCH NEXT FROM country_cursor
    INTO @COLUMN_NAME , @DATA_TYPE-- , @CountName

    WHILE @@FETCH_STATUS = 0
    BEGIN

    select @result=COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = tblPriceNew and COLUMN_NAME = @COLUMN_NAME

    if LEN(@result)0
    begin
    set @MachingColumnList = @MachingColumnList + , + @result
    --select @result
    end
    FETCH NEXT FROM country_cursor
    INTO @COLUMN_NAME , @DATA_TYPE

    END
    CLOSE country_cursor;
    DEALLOCATE country_cursor;

    set @MachingColumnList = substring(@MachingColumnList,2,LEN(@MachingColumnList))

    Declare @QueryString varchar(2000)
    set @QueryString = insert into tblPrice ( + @MachingColumnList + )
    select + @MachingColumnList + from tblPriceNew

    select @QueryString

  • RELEVANCY SCORE 3.04

    DB:3.04:Forcing Two Fields With The Same Height ap


    Hi to all...

    I have a repeating frame, and inside this, two fields with same height and one near the other just like two columns in a table. All fields and repeating frame are vertically expand.

    But the size of the data in the two fields sometimes is different. So, I want to expand the height of the smallest field to the same size of the highest.

    I need to do this because I want to create a table, with a background color, and the black spaces are fields.

    Thanks to all
    Filipe

    DB:3.04:Forcing Two Fields With The Same Height ap

    Hi,

    Thanks for your reply.
    But this doesn't work at all. Despite I have the same font type and font size, the two columns aren't shown with the same height.

    In Paper Layout I put the two fields with the same weight and height.
    I think the best way to do this is working with the field height and not with the data, because I want to guarantee that one field have the same height of the other and vice-versa.

    I try to use an anchor but with no results. :(
    Any idea?

    Regards
    Filipe

  • RELEVANCY SCORE 3.04

    DB:3.04:Ar Receipts On Account And Unapplied Fields ap


    Hi All

    Can you please help me finding out what are the database field names for On Account and Unapplied fields in AR receipts form and in which table these two fields reside?

    Please let me know asap on the same.

    Appreciate your time on this in advance.

    Regds
    Mano

    DB:3.04:Ar Receipts On Account And Unapplied Fields ap

    Thanks Octavio

    Much appreciated for your help.

    It was very helpful . Thanks a lot.

    Regds
    Mano

  • RELEVANCY SCORE 3.04

    DB:3.04:Alternative To Full Outer Join zc


    Hi,I want to display records from two tables

    It should return all the matching records from both the tables.
    If a record is present in first table and not present in second table it should retun null from the Second table and records from the First table
    If a record is present in Second table and not present in First table it should retun null from the First table and records from the second table

    I dont want to use Full outer join for the same.

    Is there any better solution for this scenario.

    Please suggest.

    DB:3.04:Alternative To Full Outer Join zc

    It must be fine to use Full Outer Join. Why don't you use it as the result should be the same if you combine one left join script and another right join script together?

    Sql Full Outer Join
    Description

    The FULL OUTER JOIN will return all rows, as long as there's matching data in one of the tables. It includes all the rows from both the participating tables and does not select either the LEFT or RIGHT table from the JOIN key word.

    The FULL OUTER JOIN combines the results of both left and right outer joins. When no matching rows exist for rows on the left side of the JOIN key word, NULL values will be returned from the result set on the right. On the other hand , when no matching rows
    exist for rows on the right side of the JOIN key word, NULL values will be returned from the result set on the left.
    Syntax
    Select *
    FROM table1
    FULL OUTER JOIN table2
    ON table1.column_name=table2.column_name ;

    Many Thanks Best Regards, Hua Min

  • RELEVANCY SCORE 3.03

    DB:3.03:Ora-02270 No Matching Unique Or Primary Key For This Column List k7


    Am trying to create a simple table which has one column which is referenced to a column in another table in the same Schema.
    i am getting this error:
    ORA-02270 no matching unique or primary key for this column list

    what could be the reason"

    the two tables are
    ----
    Employee:
    empid
    firstname
    lastname
    state
    zip
    compid
    -----
    Employee_workinfo:
    compid
    compname
    state
    zip
    -----

    The compid in the workinfo table is referenced to compid from the employee table...in the same schema.

    can somebody help me?

    mahesh

    DB:3.03:Ora-02270 No Matching Unique Or Primary Key For This Column List k7

    The key that you are trying to refer must have primary key or unique constraint applied on it. See that you have either of the constraint applied on it

  • RELEVANCY SCORE 3.03

    DB:3.03:Qvw File Size Behavior Before And After Dimension Modification js



    Hi to all,

    i'm been studying "Qlikview Developer 11" and i noticed a curious thing in an exercise.

    There is a fact table and different dimensions. In several dimensions there are non-matching values with the fact table, then is suggested how delete this non-matching values from the dimensions to reduce the size of the qvw.

    To simplify i have loaded only one dimension (in addition of the fact table), before with non-matching values and after without.

    From an original dimension of about 55MB, after i have a qvw file of about 33MB.

    But, if i try to load only the fact table, the file size is about 54 MB.

    The question is ... how it is possibile?

    There is a compression of the data model only when i have loaded more than one table?

    Summary

    Size of file qvw loading one table at a time:

    54273 KB Only fact table (57 fileds x 1256075 records)

    255 KB Dimension with non-matching values (2 fielsds x 6209 records)

    183 KB Dimension without non-matching values (2 fields x 2142 records)

    54388 KB - Fact table and dimension with non-matching values :

    Tables#Records#Fields#KeysFact Table1256075571Dimension620921

    34901 KB - Fact table and dimension without non-matching values :

    Tables#Records#Fields#KeysFact Table1256075571Dimension212421

    The records number of the fact table is the same, because QlikView perform a full outer join, then there isn't a subset of record for the fact table driven by the dimension filtered (in case of a inner join).

    For completeness, the fact table is loaded from a qvd, while the dimension from an access table.

    Can someone help me understand this behavior?

    Thank you all !!

    Saverio

    DB:3.03:Qvw File Size Behavior Before And After Dimension Modification js


    Hi to all,

    i'm been studying "Qlikview Developer 11" and i noticed a curious thing in an exercise.

    There is a fact table and different dimensions. In several dimensions there are non-matching values with the fact table, then is suggested how delete this non-matching values from the dimensions to reduce the size of the qvw.

    To simplify i have loaded only one dimension (in addition of the fact table), before with non-matching values and after without.

    From an original dimension of about 55MB, after i have a qvw file of about 33MB.

    But, if i try to load only the fact table, the file size is about 54 MB.

    The question is ... how it is possibile?

    There is a compression of the data model only when i have loaded more than one table?

    Summary

    Size of file qvw loading one table at a time:

    54273 KB Only fact table (57 fileds x 1256075 records)

    255 KB Dimension with non-matching values (2 fielsds x 6209 records)

    183 KB Dimension without non-matching values (2 fields x 2142 records)

    54388 KB - Fact table and dimension with non-matching values :

    Tables#Records#Fields#KeysFact Table1256075571Dimension620921

    34901 KB - Fact table and dimension without non-matching values :

    Tables#Records#Fields#KeysFact Table1256075571Dimension212421

    The records number of the fact table is the same, because QlikView perform a full outer join, then there isn't a subset of record for the fact table driven by the dimension filtered (in case of a inner join).

    For completeness, the fact table is loaded from a qvd, while the dimension from an access table.

    Can someone help me understand this behavior?

    Thank you all !!

    Saverio

  • RELEVANCY SCORE 3.03

    DB:3.03:Understanding Join, Keep And Concatenate f1


    We have implemented the QlikView Join, Keep and Concatenate in QvScriptor, a new revolutionary tool, able to generate QlikView script from visual schema.

    We have written this small doc for the help file and we thing interesting to share it with the community as we found only partial explanations about the methods.

    The QlikView script functions JOIN, KEEP and CONCATENATE can sometimes be used to solve the same problem, but there are important differences that should be understood.

    Examine the sample tables below. Note that they share one common field name, "Key".

    Also note that Table1 has a Key value "3" that is not present in Table2 and that Table2 has a key 4 that is not present in Table1.

    Table1Table2Key AKey C1 A11 C12 A22 C23 A34 C4
    Type of Joins:
    JOIN will combine rows where the Key value matches.
    The keyword OUTER will also retain rows that do not match rows in the other table. The keyword LEFT will retain rows from the left table but only matching rows from the right table The keyword RIGHT will retain rows from the right table but only matching rows from the left table The keyword INNER will retain rows matching the left table and right table
    Joins
    Here's what the merged table will look like after the different join methods.

    Note that QlikView merge the two tables after a Join.

    Note: The explicit join keyword (= Outer Join) in QlikView script language performs a full join of the two tables. The result is one table. In many cases such joins will result in very large tables. One of the main features of QlikView is its ability to make associations between tables instead of joining them, which greatly reduces memory usage, increases processing speed and offers enormous flexibility. Explicit joins should therefore be generally avoided in QlikView scripts. The keep functionality was designed to reduce the number of cases where you need to use explicit joins

    OUTER JOIN (Table1)LEFT JOIN (Table1)Key A CKey A C1 A1 C11 A1 C12 A2 C22 A2 C23 A3 -3 A3-4 - C4

    RIGHT JOIN (Table1)INNER JOIN (Table1)Key A CKey A C1 A1 C11 A1 C12 A2 C22 A2 C24 - C4Keep
    The keep prefix between two load or select statements has the effect of reducing one or both of the two tables before they are stored in QlikView, based on the intersection of table data. The keep keyword must always be preceded by one of the prefixes inner,left or right. The selection of records from the tables is made in the same way as in a corresponding join.

    However, the two tables are not joined and will be stored in QlikView as two separately named tables.

    LEFT KEEPTable1Table2KeyAKeyC1A11C12A22C23A33-
    RIGHT KEEPTable1Table2KeyAKeyC1A11C12A22C24-4C4

    INNER KEEPTable1Table2KeyAKeyC1A11C12A22C2

    Concatenate
    Now let's look at Concatenate. Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated table is always the sum of the rows from the two input tables. Here's what our sample data will look like after Concatenate.

    CONCATENATE (Table1) LOAD * RESIDENT Table2;

    Key A C1 A11 C12 A22 C23 A34 C4
    Rows with like Key values are not merged together. The rows from Table2 are simply appended to Table1. Because the tables have different fields, rows will have null values for the fields from the "other" table.

    QsGen Team

    DB:3.03:Understanding Join, Keep And Concatenate f1


    Great overview. Whenever I need to explain the Join, Keep, and Concatenate commands to anyone who is learning QlikView or Qlik Sense scripting, I always showcase this post to highlight the different ways to transform tables. Thanks!

  • RELEVANCY SCORE 3.01

    DB:3.01:Multiple Fields Matching Rules x1



    Hi Guys,

    I have a problem. I like to match records depending upon multiple fields matching rules. Let's have an example. I have record consisting several fields like Customer Name, Address, Email, Telephone I like to see if all these fields values are same in two or several records.

    What I currently have is that I have made several Matching Rules and used them in one Matching but it shows me many duplicate records. Eventhough, they are not completely duplicate. What the Matching Strategy does is that if any of Matching Rules used in it is duplidate it shows me as duplicate record.

    But I like see duplicatation if all above mentioned fields are duplicated.

    Any recommendation???

    Regards,

    Naeem

    DB:3.01:Multiple Fields Matching Rules x1


    Hi Naeem,

    Yes, we can relate the main tables as well.There is a field type called Lookup(Main)

    so that we can look up into other main tables also like Hierarchy and Taxonomy tables.

    I dont think we can see the relationships between tables in the form of logical diagram

    in the console.

    Thanks and Regards,

    Preethi

  • RELEVANCY SCORE 3.01

    DB:3.01:Matching Two Fields In Same Table fm


    I have a table with two columns containing Names (NameA and NameB columns)

    I want to match these two columns to find which rows don’t match, meaning they have different characters.

    TableA

    NameA
    NameB
    James Bond James Bond
    Steve Ray Steve Ray
    Ellie Golden Natasha Kiss

    So the end result would return the last row only as the two names don’t match, how can I write a sql script to do this

    DB:3.01:Matching Two Fields In Same Table fm

    Try
    select *
    from TableA
    where NameANameB;Many Thanks Best Regards, Hua Min

  • RELEVANCY SCORE 3.01

    DB:3.01:Oibt Table And Dtw 8k



    Hello there,

    I got my OIBT Table that I use to handle Batch. Now I added two useer fields. One is U_GrossWeight and the other is U_ReelNr.

    Now I have to use DTW to make an Goods Receipt, so I prepared the 3 file OIGN-IGN1-OIBT (Document-DocumentLines-Batch) but there is no way to make a matching with my user field in the OIBT Table.

    How can I achive that?

    Thank you

    Roberto

    DB:3.01:Oibt Table And Dtw 8k


    Hello Beverly - nice to see you on the Forum...

    :-)

    Zal

  • RELEVANCY SCORE 3.00

    DB:3.00:Probelm Updating Mara Table, When Adding New Z Fields To Mm01/Mm02 zz



    Hi

    I hava a requirement to add two new fields in Basuc data1

    screen of MM01/MM02/MM03 transaction.

    In MM01, there were some customer fields added previously and

    those fields properly updating in MARA TABLE when saved

    I have added my new 2 fields in MARA table using Append Structure

    And I have added my 2 new fields in the same existing previously added

    subscreen and I have added my new fields in T130F table.

    But when I try to change exisitng material with MM02, I am trying put some

    values in my new fields and if I save it, its saying "No Changes made"

    Means itsnot updating my values to MARA table.

    Can any one help me, are there any additional steps I need to do to

    update the values in MARA table.

    Thanks

    Kishore B A

    DB:3.00:Probelm Updating Mara Table, When Adding New Z Fields To Mm01/Mm02 zz


    Hi Kishore,

    You have to do the coding in the function exit EXIT_SAPLMGMU_001 to update the new Z fields.

    Regards

    DKS

  • RELEVANCY SCORE 3.00

    DB:3.00:Doubts In Returning Values From Function k8


    Hi All,

    I have a doubt that returning values from a Function.

    I have a table with two fields,i want to return the two fields from the function.

    Is that possible?

    For ex:
    ----------

    Table
    -------
    Id --- Value
    1 --- 'Yes'
    2 --- 'No'

    I want to return the values like the same in the table with two different fields
    Else
    I need to return like 1,2-Yes,No.

    How can i do this?

    Thanks

    DB:3.00:Doubts In Returning Values From Function k8

    You can try with REF cursors ...
    Check out documentation on:
    http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/sqloperations.htm#i7106

  • RELEVANCY SCORE 3.00

    DB:3.00:Fetching Data From Two Seperate Fields s1



    Hi,

    I have 2 tables WarrantyClaimMaster and TReportMaster. WarrantyClaimMaster has a field TractorSrNo which is aliased as TrSrNo and TReportMaster has a field TractorSrNo. Now i want to display count of TractorSrNo from table TReportMaster in my first expression and how many of those count, matches with TrSrNo of WarrantyClaimMaster table.

    The problem here is , my first expression should vary based on the calender, but the second expression should give all the matching count from TrSrNo irrespective of year and month.

    Also WarrantyClaimMaster table and TReportMaster table are concatenated to make common date field. Hence TractorSrNo and TrSrNo in the same table after reloading.

    Thanks in advance

    Sandhya Gowda

    DB:3.00:Fetching Data From Two Seperate Fields s1


    Your sample qvw seems to be blank. Re-upload with a small set of data and try to explain expected output against at least two different selections with logic explanation.

  • RELEVANCY SCORE 2.99

    DB:2.99:Saving The Screen Entries In The Database Table ks


    Hi All,I have two fields in ztable(Database) namely by name and contact number.And in the same way i have referred this dictionay fields and place a two set of fields in my screen like name number
    name number

    DB:2.99:Saving The Screen Entries In The Database Table ks

    Create a Table of type you Table.Now select all data from the table.Do READ with INDEX 1 and check for 1st 2 entries, if different, call UPDATE by passing the 2 values to a Work-Area of that Table Type.Repeat the Above steps with INDEX 2 for second row.

  • RELEVANCY SCORE 2.99

    DB:2.99:Concat 31



    Is it possible to concat two fields in the same table n how?

    DB:2.99:Concat 31


    Hi ,

    what you want to say is concatenating fields means creating a composite

    key then waht arun Goel is saying is correct.

    Warm Regards

    Anant Dubey

  • RELEVANCY SCORE 2.99

    DB:2.99:Correcting The Decimal Value In Script mf


    Hi,

    I am loading data from two different tables but amount value are not matching after decimals for same documents ,I want to match these table and eliminate duplicate. Since Amount flied are not same I am unable identify duplicates .Can anyone help to correct Decimals values.

    I have tried Num(Num#( '[Amount ]'),'#,###.##')) and Num(Num#( '[Amount in LC_DMBTR]'),'#,###.00')) but its not working

    Table 1

    DocAmount1900.0021000.53100.554200

    Table 2

    DocAmount190021000.503100.554200.00

    DB:2.99:Correcting The Decimal Value In Script mf


    Its not working ,I have tried floor(), ceil() also

  • RELEVANCY SCORE 2.99

    DB:2.99:Compare Data And Mark The Common One xc



    Hello.

    I attached a qvw file that has two inline tables that have common data with different fields.

    I want to show in a chart all the data that the second table has and in a new column i want to have 0 for the data that not matching with the first table and with 1 the data that matching with the first table.

    How can i express this in the expression of the chart.

    Thank you in advance.

    DB:2.99:Compare Data And Mark The Common One xc


    Yes, but maybe all the project is not so complicate. I want to show only the data of the second table with a new column that will have 0 as not match and 1 that match and your example bring and other data.

    Why i have to join the two tables ? With if command i take the common ones and also i take all the data of the second table but i can not mark as 0 (not find) and 1 (find)

    Is there any expression from the first qvw i have attached that i will have the results i want ?

  • RELEVANCY SCORE 2.98

    DB:2.98:Shutlle Control And Inserting Data To One Table.... pz


    I have a shuttle control on a form with two other fields. I select three names from the shuttle and want to insert three new records to a single table with the same other two fields. Can someone point me to an example of how to do this in APEX?
    John

    DB:2.98:Shutlle Control And Inserting Data To One Table.... pz

    Thank you. That worked.
    John

    Edited by: jfr620 on Jul 30, 2012 1:59 PM

  • RELEVANCY SCORE 2.98

    DB:2.98:Promotelookup Problem pa


    Hi,    I was wondering if anyone could give me an answer to a problem I'm having please.I have a table - Table A which has two columns which lookup Table B for a description matching their code values.  I apply the IsLookup methods and all is fine, the description values from Table B are showing in Report Builder for the relevant columns in the entity representing Table A.Table B however lookups Table C for a description value also, which I want to display twice in the entity representing Table A, one for each of the columns related to Table B.I apply the PromoteLookup method and when I look at Report Builder at the entity representing Table A, in the available fields I see two description fields promoted from Table C.  The problem occurs when I build a report however.  I get the two descriptions from Table B displayed, but I'm somehow getting four instances of the Table C descriptions.  The data is correct in that two of the Table C columns match each of the Table B columns.  I can't understand the repeating columns though.Can anyone suggest something I may be doing wrong in the model design, or is having two columns in one table related to the same table in this way poor database design?  I had never considered as such before.Thanks,Lee.

    DB:2.98:Promotelookup Problem pa

    Hi,      many thanks for your reply.  I should have mentioned  this is RS 2005 and I don't think sub-reports are a feature of Report Builder until Report Builder 2.0, in RS 2005 they are only available in VS?
    Really the functionality I need is present in RS2005 models, it's just that I'm getting an unusual result.  In Report Builder I want to promote the look-up of Table C to Table A, which works no problems when Table B relates to one column in Table A, so that the end-user sees a fully denormalized entity for Table A.It's just when I have more than one column in Table A looking up Table B that I am getting duplication of Table C columns at run time (4 Table C columns instead of 2).Thanks again,Lee

  • RELEVANCY SCORE 2.97

    DB:2.97:Retriving Data From Two Tables At A Time. fz


    Please use this forum to provide feedback about OTN content/services. All other posts will be DELETED.
    hi all,
    Am using win98 and Oracle 7.
    I have splitted a table into two tables having 10 and 9 fields respectively and records of 2000.Now in form builder I have put both tables in same block and on same canvas.
    Now when I execute a query I retrieve records of 1st table and can navigate through records of 1st table only .To retrive records of 2nd table I have to put curser in 2nd table and query again for data retrival from 2nd table.This is bothering me to match coulmn of both tables.

    Is there any way to execute the records of both tables at a time, so that matching coulmns of both tables would become easy to reach.

    Thanks and Regards

    DB:2.97:Retriving Data From Two Tables At A Time. fz

    heeeey mohammad
    you have first to make master/detail block not one block only
    then jion between them as pk and fk

  • RELEVANCY SCORE 2.97

    DB:2.97:How To Compare Two Fileds In A Spreadsheet And Get The Count Of Mismatched Items jj


    I have a spread sheet and it contains two fields ,containing names. Field A and Field B contains same data,but unfortunately some entries in Field B is different from that of A.I want to get the entries ,which are not matching ,to be sorted out or highlighted.

    Thanks In Advance

    Celesta Joseph

    DB:2.97:How To Compare Two Fileds In A Spreadsheet And Get The Count Of Mismatched Items jj

    Hi if you really want as your snapshot above, we can simply achieve by a simple formula:
    -in Cell C2 just input: =A2=B2
    -then copy paste formula up to C6 then you can get same result as your snapshot.
    Please have a try...

  • RELEVANCY SCORE 2.97

    DB:2.97:Matching Mode 39



    Hi All,

    I was trying on matching mode.

    I entered two same record and came into matching Mode in Data manager. I selected one of those record(same records) and clicked on "Matches" tab but i did not get potential matching reocrd (Though I had already entered same record)

    Can anyone tell me how to work in Matching Mode .

    Please mention some example too

    Thanks

    Jyoti

    DB:2.97:Matching Mode 39


    Hi Jyoti,

    Regarding your question about Max Score and Min Score:

    1. Create Rules and assign the Success Rate or Failure Rate.

    I will try to explain by an example:

    Suppose you feel that the Feild1 has a High potentail of being a duplicate. Then suppose you assign a success rate of 40.

    and similarly for Field 2 - 35

    Field 3 - 25.

    2. After this when you create a startergy and include (tick) all your Rules. The total of the success rate will come as the Max Score : 100.

    As mentioned above also, you cannot edit the max and the Minscore.

    Additionally, High Threshold and Low threshold will decide the result of the Stratergy you are running.

    I hope it helps.

    Thanks and Regards

    Nitin Jain

  • RELEVANCY SCORE 2.96

    DB:2.96:Keyword Query Join 87


    Is it possible to create a join with Keyword Query Language? I can create two queries and get them executed at the same time using the SearchExecutor class, but the result is just accumulated.

    I've created a query that returns (among other fields) a ListItemID that corresponds to items in a specific list. Is it possble to pick up fields in that list for the matching id and present it all in one table?

    DB:2.96:Keyword Query Join 87

    I'm sorry if I was a bit vague, let me elaborate:
    Let's say that my query returns 100 items. For each item I get 10 fields/properties using the
    SelectProperties.Add method. I also have a custom list containing more information about some of my returned items. I need 3 fields from this list. One of the fields returned by my query is a key that matches a field in the custom list.
    Right now I issue the query, get a result table and then loop through the table rows seaching my custom list for any additional information. This is also done by a KQL query but it would be nice to get rid of this iteration and get everything in one go,
    e.g. one result table with 13 fields instead of 10.
    I hope this makes it more clear.

  • RELEVANCY SCORE 2.96

    DB:2.96:Is This Even An Iif Expression Question aa


    Working in ACCESS 2007, I have two tables. In Table1 I have TextField1. In Table2 I have TextField2 which is the same type text as TextField1 that I need to test for a match. I have a second text field in Table 2, TextField3, that is the same type
    text data. These tables come from two separate vendors so I have no control over how they are constructed. I need to ask Access to bring back all the records in Table1 and to look at [Table1].[TextField1] and if it is = to [Table2].[TextField2] bring back
    the matching records from Table2. But if there is no match I need ACCESS to then look at [Table2].[TextField3] and if there is a match bring those matching records back. If none of the three fields match, insert “no match” for [Table2].[TextField2] and [Table2].[TextField3].
    I’ve struggled for months to make this happen without Making a Table then Appending as I have too many of these to do for that to be an efficient approach. Any ideas please! Thanks.

    DB:2.96:Is This Even An Iif Expression Question aa

    I'm very new to SQL so I'm easily confused. Your reply added some elements that were confusing but when I worked through them I was able to remove what I didn't need. I think this is actually what I needed.

    SELECT Table1.TextField1, (plus a couple fields that I needed to make sure I was getting what I wanted.)
    FROM Table1 LEFT JOIN Table2 ON Table1.TextField1=Table2.TextField2 OR Table1.TextField1=Table2.TextField3

    So farevery test I've performed has responded exactly as I had hoped.You've cracked the code for me. So thank you very much.
    m

  • RELEVANCY SCORE 2.96

    DB:2.96:Filter - Push Fields Action - Source Data Question f9



    I am attempting to do this, but thought I would ask the question first.

    I need to create a fitler on a regular form (has more than 200 fields with values) that does a table loop on configuration data in another form and pushes all the 200 field values except for two fields (these come from the table column) to itself. Consider this a one level of recursion.

    Instead of having a Push Fields action with all the fields individually listed and the two values being substituted from the table field columns, I was wondering if it is possible to do a set fields action to set the value in the two fields from the table columns in the first action of the filter and the second action does a Push Fields action with Matching IDs.

    We are on AR Sever 7.1.0.

    Anyone done this before and can share their experience/comments?

    Thanks,

    --

    Shyam

    DB:2.96:Filter - Push Fields Action - Source Data Question f9


    I am attempting to do this, but thought I would ask the question first.

    I need to create a fitler on a regular form (has more than 200 fields with values) that does a table loop on configuration data in another form and pushes all the 200 field values except for two fields (these come from the table column) to itself. Consider this a one level of recursion.

    Instead of having a Push Fields action with all the fields individually listed and the two values being substituted from the table field columns, I was wondering if it is possible to do a set fields action to set the value in the two fields from the table columns in the first action of the filter and the second action does a Push Fields action with Matching IDs.

    We are on AR Sever 7.1.0.

    Anyone done this before and can share their experience/comments?

    Thanks,

    --

    Shyam

  • RELEVANCY SCORE 2.96

    DB:2.96:Display Field Based On Two Other Fields Matching aj



    I would like to list the contents of a field from one table on a new table. I would like to list the contents of the field when two other fields match. For example I have table A which has field A in it. However i only want to show
    this field when field B in table B and field B in table A equal each other. How can I build a criteria to do this?

    DB:2.96:Display Field Based On Two Other Fields Matching aj

    Hi,
    What do you want to know ? how to select data where ? SQL data ? if SQL so you need to use SQL query:

    Select FieldA From TableA where TableA.FieldB=TableB.FieldB
    Regards

  • RELEVANCY SCORE 2.95

    DB:2.95:Compare Fields In Two Tables 3a


    Hi Guys,

    I have two tables with same structure and having 12 fields inthat tables. now i want to match the atleast three fields.i.e suppose
    c11 oracle c21 oracle1
    c12 vb c22 vb
    c13 sybase c23 sybase like... i want to compare each and every field matching or not, if matching update the 12column. can u please explain the logic and example for this...thanks in advance

    DB:2.95:Compare Fields In Two Tables 3a

    I'd like to know which of those two tables has to be updated. If it would be for example t1, all you would have to do is:

    UPDATE t1
    SET t1.c14 = (SELECT t2.c24
    FROM t2
    WHERE t2.c21 = t1.c11
    AND t2.c22 = t1.c12
    AND t2.c23 = t1.c13)
    WHERE EXISTS (SELECT 1
    FROM t2
    WHERE t2.c21 = t1.c11
    AND t2.c22 = t1.c12
    AND t2.c23 = t1.c13
    AND t2.c24 t1.c14); C.

  • RELEVANCY SCORE 2.94

    DB:2.94:Matching Fields On Import 89



    I've created a FileMaker Pro 12 database with 15 tables, which will be used to create 20 runtime solutions.

    I've writing a FM script to merge (i.e. import) the contents of the runtime solutions into a single database.

    Two big problems, which seem ridiculous to me, so I must be missing something (I hope):

    1) There doesn't seem to be any way to pre-select the source table automatically i.e. To say "match the fields in the source and destination tables named Staff" (I can only specify the destination table), which makes it impossible to do this without bringing up the import dialog box (15 * 20 times each time a merge is done).

    2) Even when I do this manually with the import dialog box and have "matching names" selected, not all fields are being matched correctly.

    Kap

    DB:2.94:Matching Fields On Import 89


    Hi

    Glad you got it working.

    The issue with XML is that you have to export the data first, then import.

    So if it is a large data set it can take awhile.

    Bruce

    Sent from my mobile device... Please excuse typos.

  • RELEVANCY SCORE 2.94

    DB:2.94:Update Statement 98


    Hi All
    I want to write an update statement mine table is like

    Col1

    Col2

    Col3

    Col4

    Col5

    1

    2

    3

    8

    9

    1

    2

    3

    7

    4

    2

    5

    8

    0

    2

    2

    5

    7

    5

    5

    1

    2

    3

    6

    5

    3

    4

    5

    7

    7

    3

    4

    5

    1

    4

    Now update statement is depend on
    Suppose first 3 columns are same for any row like in my table consider first two rows are same for first three columns SO i want to update 4th column of 1st row and it should be 5th column of 2nd matching row
    lets see in table 4th column of 1st row should be replace by 5th column of second row means 8 is replace by 4
    Now same in table 2nd row and 5th row are matching for first 3 columns so in 2nd row 4th column (7) should be updated and is replace by same 5th column of matching row means 5th row 5th column which is (5)

    Same for all the rows
    So if first three columns are matching for any two rows
    then 4th column of 1st row is i want to update by 5th column of that matching another row

    Please help me out

    DB:2.94:Update Statement 98


    yup and after update resulting rows should be

    1-1,2,3,4,9
    2-1,2,3,5,4
    3-1,2,3,6,5

    I am not communicating well myself. My question to you is, what criteria we should use to sort the rows in chronological order?
    1, 2, 3, 8, 9 -why this row should be considered as 1?
    1, 2, 3, 7, 4 - why this row should be considered as 2?
    1, 2, 3, 6, 5 - why this row should be considered as 3?

    AMB
    Some guidelines for posting questions...

  • RELEVANCY SCORE 2.94

    DB:2.94:Joining Data From Tables In Excel Or Access a9


    I have two tables in excel. Table 1 has a column of town names and a column with a matching place name number ID (from the USGS). There are multiple entries for some towns and so multiple place name IDs. There are also other fields in this table. Table
    2 has the unique place name ID and two other columns, one for latitude and one for longitude. There is ony one entry for each unique place name ID in this table. What I want to do is use Table 2 to input the correct latitude and longitude fields into Table
    1. Table 2 includes many more unique IDs that are not in Table 1. Table 1 has, as I've said, multiple entries for some place name IDs and I want to get the matching latitude and longitude for each of these. I am new to this, so any help or pointers would
    be greatly appreciated. I am using Excel 2010. I can also cut and paste this info into Access 2010 if it would be easier to work with in there

  • RELEVANCY SCORE 2.94

    DB:2.94:Comparing Two Data Tables 19


    I have a form which has two data tables with the same schema. They have the following schema
    pk_Items (Primary Key, guid)
    ItemKey (Integer)
    Additional fields
    I want to remove from the first table any rows that have a matching item key in the second table.
    How can I do this?

    Thanks

  • RELEVANCY SCORE 2.93

    DB:2.93:Maximum Value Matching With Value In Other Table For Same Id kk


    I have two tablesTable1IDSalary111225330Table2idsalary1218111118212218225Need to find out Table1.id values where Table1.Salary = Table2.max(salary) where Table1.id = Table2.idExpected Results-- 2, 25 Need to find out Table1.id values where Table1.Salary = Table2.max(salary) where Table1.id = Table2.idExpected Results= 1, 11 3,30

    DB:2.93:Maximum Value Matching With Value In Other Table For Same Id kk

    HI , Group by clause must be added to the above query to avoid ORA-00937: error,SELECT *FROM f_t1WHERE (id, salary) NOT IN ( SELECT id , MAX (salary) FROM f_t2 group by id );Regards,Soundariya Kumar.R

  • RELEVANCY SCORE 2.93

    DB:2.93:Criteria With Master Detail sf


    Using windows Jdev 11.1.1.4 in application JSF. I have two Objects View linked by View Link. First View is Master and second is Detail. I don' t use "Entity Usage". I defined field by sql statement (in Object View into field Info I view Calculated.....). Also in first View Object I defined Key Attribute and I defined the same Key Attribute in the other View Object. I used the same fields in View Link.
    In first (Master) Object View I created a criteria (I don't create criteria in detail View Object).

    I created .jspx. I dragged from "Data Controls" the Detail Object and I choosed Master Table and Detail Table. I also dragged the Criteria and I setted property of af:query ResultComponentId at Master Table.
    When execute the application works properly (I choose the line in Master table and I see the Detail table properly loaded) but I read in Log of IntegratedWeblogicServer:

    *SimpleSelectOneRenderer _getSelectedIndex Could not find selected item matching value "criteriaByDate" in QueryRenderer$2[UIXEditableFacesBeanImpl, id=null]*

    I read this message every time I choose Master table row.
    Thanks

    DB:2.93:Criteria With Master Detail sf

    I resolved.
    I must change ChangeEventPolicy in ...ViewIterator into PageDefs for Detail table.

  • RELEVANCY SCORE 2.93

    DB:2.93:Joining Two Datasets xm


    In my scenario,I have two data sets,both view and table are in same database.

    Dataset1:pulling fields from existing view(the data is coming from more than 10 tables)

    In dataset2:Pulling the fields from table

    can i join these two data sets to place all the fields in report?

  • RELEVANCY SCORE 2.92

    DB:2.92:Group Matching Fields Onto Same Row zc


    How canI group matching ID fields together onto one column? So for the following raw dataset
    ID Subject
    F45038 Maths
    F45038 Art
    F90659 Science
    F65745 History
    should be shown as the table below
    ID Subject
    F45038 Maths -/- Art
    F90659 Science
    F65745 History
    Notice that I seperated the two distinct fields with a -/-

    DB:2.92:Group Matching Fields Onto Same Row zc

    The separater Rishabh used was three characters long, that is '-/-'. Did you do something like using one that was longer, like maybe ' -/- ', that is it is now 5 characters long? If so, you need to change the third parameter in the stuff function
    to whatever the lenght of the separater you used. So where Rishabh has 1,3,'' you would want 1,5,'' (or whatever the length of the separater you chose.
    Tom

  • RELEVANCY SCORE 2.92

    DB:2.92:Joins cp


    I have two tables A and B with same columns

    Table A
    col1 | col2 | col3
    ab | bc | cd
    sy | sd |ar

    Table B
    col1 | col2 | col3
    sy | sd |ar

    I have a scenario where table A has some records in it and Table B has got some records in it.

    I want to insert a row in Table B from Table A if the Table B doesn't have a matching record.
    If the record exist it should not insert that record.

    so it should only insert
    ab | bc | cd

    How can I do it using the joins.

    Thanks

    DB:2.92:Joins cp

    The last code is not using joins however I guess the following code will help you.
    INSERT INTO B
    (SELECT A.*
    FROM A JOIN B ON
    A.col1 B.col1 AND
    A.col2 B.col2 AND
    A.col3 B.col3;)

    this one is using ANSI join

  • RELEVANCY SCORE 2.92

    DB:2.92:Creating Insert And Update Sql On The Fly f8


    Hi
    I need to update or insert records from one SQL Server table to another depending on if records with PK values already exist in the destination table or not. The fields can change between the two tables over time. Therefore I need to make Insert and Update
    sql strings on the fly to update fields that have the matching field names between the two tables.
    My question is how can I retrieve the list of fields in the two tables to create SQL strings?
    Thanks
    Regards
    Yahya

    DB:2.92:Creating Insert And Update Sql On The Fly f8

    I believe SqlCommandBuilder class will do this for you. See
    http://www.dotnetperls.com/sqlcommandbuilderfor details.Matt

  • RELEVANCY SCORE 2.92

    DB:2.92:Matching Values Through Unique Id jc



    Hi all,

    I have the following table coming in;

    IDJoin_IDValue1111X21117222124424222224333TEST6333

    If two (or more) IDs have the same Join_ID, I need their Values to be the same.

    How can I do this in QV code?

    Thanks!

    DB:2.92:Matching Values Through Unique Id jc


    hi,

    thanks for the help.

    question: is it possible to have the final solution in the same format as my initial table using your code above? I need to keep all the fields.

    thanks

  • RELEVANCY SCORE 2.92

    DB:2.92:Internal Table 83



    Hi ,

    I have two internal tables with two fields one is custno , and desc. In the first internal table I have custno . In the second intenal table I have both custno and description also . My Problem is I have to add this description to the First Internal table custnos matching.

    What is the Simplest way for this logic ?

    Bye,

    Muttu.

    DB:2.92:Internal Table 83


    Hi Satyanaraya,

    If your ITAB1 has Custno and ITAB2 has Custno and Desc then do as follows.

    DATA V_TABIX TYPE SY-TABIX.

    SORT ITAB1 BY CUSTNO.

    LOOP AT ITAB2 INTO WA_ITAB2.

    V_TABIX = SY-TABIX.

    READ TABLE ITAB1 WITH KEY CUSTNO = WA_ITAB2-CUSTNO BINARY SEARCH.

    IF SY-SUBRC = 0.

    ITAB1-DESC = WA_ITAB2-DESC.

    MODIFY ITAB1 INDEX V_TABIX TRANSPORTING DESC.

    ENDIF.

    ENDLOOP.

    Thanks,

    Vinay

  • RELEVANCY SCORE 2.92

    DB:2.92:Concatinating Two Fields.. 3p



    Hello,

    Which is the best way to concatenate two fields from a same table. For ex. I have two FName and LName in the table of the database MS Access, I want to load it and display it as the FullName field in QV report.

    Thanks N Regards..

    Ravi

    DB:2.92:Concatinating Two Fields.. 3p


    Load FName , LName , FName ' ' Lname as FullNamefrom yourtable
    jj

  • RELEVANCY SCORE 2.92

    DB:2.92:Cost Not Matching md



    Cost is not matching in Report

    S_ALR_87013532 It's drill down report sum.

    Same is case for Table RPSCO COEP for particular project.

    Nopt solved even after running CJEN.

    Please guide.

    SSanjay

    DB:2.92:Cost Not Matching md


    Solved.

    Run CJVC.

    Value Category Customising Assign Cost ELements to it.

    SSanjay

  • RELEVANCY SCORE 2.91

    DB:2.91:Hash128 p7



    Hello,

    We have table A linked to table B by a field (key). We create two separate QVD for table A and table B in separate QVW application

    These keys are complex and I use hash128 function in each QVW.

    But it seems hash128 algorith is different between QVW because some keys don't match (test have been made to verify key matching without hash128) when loading A.QVD and B.QVD in new QVW application.

    Matching OK if table A and table B hash128 is made in the same QVW application.

    Matching not the same if table A and table B hash128 is made in different QVW applications.

    Have you ever noticed that ?

    Best regards

    Rgis

    DB:2.91:Hash128 p7


    rgluzman wrote:What does it mean "collisions" and "collisions resolutions" please ?
    Wikipedia can explain it much better and more thoroughly than I can:

    http://en.wikipedia.org/wiki/Hash_function

    But I'll give it a shot. You're mapping some big compound key, say 100 bytes, into only 128 bits (16 bytes). It is IMPOSSIBLE to map EVERY 100 byte value into 16 bytes. So the hash function is simply trying to distribute your values as evenly as possible, to assign a random-looking but easily-reproduced value to each input value. A good hash function will tend to do a very good job of mapping your keys to unique values, but this is ultimately an impossible task unless it has as many bytes available as your input. So sometimes, two different input values will map to the same output value. For instance, "ABC" might map to 5, but "DEF" might ALSO map to 5. That's a collision. Well, it can't assign 5 to BOTH of them because it must give you a unique value. So it uses a second algorithm to search for an available value that hasn't been used yet. So it might then map "DEF" to 7 because nobody has used 7 yet. That's the collision resolution.

    And that's all just fine if everything's in one application. Even though it isn't what the hash function assigned, DEF will still always be mapped to 7 in that one application.

    But what happens if both ABC and DEF are in different applications? Well, in your first application, ABC will map to 5. In your second application, DEF could map to 5 as well, because it's likely that nothing else will have taken the 5 spot in your second application. Now you have, I suppose you could say, an "unresolved collision".

    With a 128 bit hash function, you have a VAST number of possible key values, 2^128, or over 3.4*10^38.

    Let's see, looking up the probability since it's been way too long since I had a probability class, and assuming I'm getting this right:

    The probability of a collision for N random keys = 1 - (2^128)! / ((2^128)^N * (2^128 - N)!)

    And that's, uh, really not going to be computable, directly, on any computer. So, OK, what about an approximation function?

    The probability of a collision for N random keys is ABOUT 1-e^(-N^2/(2*2^128)) is ABOUT 1-2.7182818^(-N^2/2^129).

    So let's say you have ten million random keys. The chance of a collision with an ideal hash algorithm is about 1-2.7182818^(-10000000^2/2^129) = 0 to as many decimal places as Excel will calculate. Microsoft's calculator seems to be indicating 0 out to 25 decimal places or so. In other words, the chance of collision is ZERO for all practical purposes.

    Now, your data isn't perfectly random, and the hash algorithm isn't some ideal thing that perfectly distributes your input data, so perhaps the chances are higher. However, it does still seem EXTREMELY unlikely that this is actually causing your problem. I STILL wouldn't use a hash algorithm in this way, because it can cause problems in theory, but it'll probably never cause problems in practice.

    So we probably need another explanation for what you're seeing.

  • RELEVANCY SCORE 2.91

    DB:2.91:Pl/Sql 88


    Hi
    Any one can tell me How to compare two diffrent table column data type and size
    column by column ...........
    like emp table having 8 column and dept having 3 column mean both table having different column,dayta type and size
    i need matching column and not matching column names in seperatly .

    DB:2.91:Pl/Sql 88

    991146 wrote:
    T hank's 4r help me................You don't have to keep saying it... I think he will have noticed the first time.

  • RELEVANCY SCORE 2.91

    DB:2.91:A Matching Table Key Doesn't Exist In Table xj


    Hi guys,

    I imported several tables from physical layer in administration tool. Then I want to make new foreign key join between those tables in physical diagram.
    Fields needed to link between those tables are set up. When I press ok button, a message error shows :
    "a matching table key doesn't exist in table blablabla. Do you want to create one ?"

    What is actually this error ? I don't have idea about this at all. The type number of the fields are the same, the names are also the same. I think it shouldn't have any problem to make new foreign key. But why does this happen ?

    Thanks

    DB:2.91:A Matching Table Key Doesn't Exist In Table xj

    Hi,

    This is about the Primary key in the first table. You might not have defined that column as a primary key for that table at db level.

    Thanks,
    Imtiaz.

  • RELEVANCY SCORE 2.91

    DB:2.91:For Fa Tax Interface Table I Want Some Fields cc


    I want to extract some fields like ytd_deprn, accumulate depreciation and cost for the conversion.
    Bascially i am doing conversion from 11i to R12 for that i want to extract data from 11i and want to load these records in R12 interface table fa_tax_interface table. When i am extracting the data from the table fa_deprn_summary/fa_deprn_detail data are not exactly matching with 11i tax data on which some are matching and some data are not matching with 11i data.
    i want to know whether these data are stored and in which table?

    DB:2.91:For Fa Tax Interface Table I Want Some Fields cc

    Well, what are you reconciling to? You are looking at something that seems to be different from your data extract, so what is that thing? My trouble shooting process is to take an asset that seems to be wrong and reconcile from the report/screen data to the extract data. You have to figure out what Oracle program is involved and what kind of SQL that the program is doing and what tables it is looking at. This could be an Oracle program error. I just ran into a problem on the Payables Posted Invoice Register report, where the total did not match my extract total. Turns out the report was wrong. If I had table records with a date/time stamp value (instead of just a date stamp value) in the accounting date field for the TO ACCOUNTING DATE value in my report request selection, those records were being dropped from the report. I reported this to Oracle support and found out that there is a patch to fix the problem (happens when cancelling an invoice) and a data script to follow to fix the historical data. So you have to keep an open mind. Yes, trying to find a reconciling issue can be very painful.

    My reaction is that you are looking at the right tables. There is also a FA_DISTRIBUTION_HISTORY table that you may want to look into, that links back to the FA_DEPRN_DETAIL table. Maybe your issue lies there. At least something to look at.

    John Dickey

  • RELEVANCY SCORE 2.90

    DB:2.90:How To Do A Lookup And Merge At The Same Time kp


    I have two tables: A and B A has following fields, it has say about 10,000 records: useid A1 A2 A3 A4 B has following fields, it has let's say 5000 records: Userid B1 B2 B3 B4 What I need is finding the matching userid in A for B, and then create a table called AB as: Userid A1 A2, A3 A4 B1, B2, B3, B4 Basically, each time I perform a lookup, I will need to append to the table AB.  For the very frist time since the table AB is not existing, can I create it on the fly? Just like clicking on the NEW button when defining a SQL SERVER DESTINATION connection creating the destination table. Thanks in advance !

  • RELEVANCY SCORE 2.90

    DB:2.90:Some Strange Logic To Be Implemented In Sql cf


    I am having the following logic. And I am not getting any thought on how to implement this in a SQL. Please give me an idea on how to proceed with this.

    In short there are two tables with key and prefix as fields. What ever key available in Table1 if available in Table 2 we should apply the second condition of Prefix. I am not getting any thought on this Please help me.

    [If the 7 byte key number on the primary Table matching key on the Abstract AND If there is only one prefix on the Abstract] or
    [If the 7 byte key number on the primary Table matching key on the Abstract AND If there is duplicate prefix on Primary Table AND matching prefix on the Abstract] OR
    [If the 7 byte key number on the Primary Table matching Key on the Abstract AND If there is duplicate prefix on Primary Table AND not matching prefix on the
    Abstract AND matching term or branch]

    DB:2.90:Some Strange Logic To Be Implemented In Sql cf

    You need to play with SUBSTR() somewhere...

    Nicolas.

  • RELEVANCY SCORE 2.90

    DB:2.90:Stumped Query zc


    I have been staring this one in the face all day. Please help. I have two tables. The first one is a clean table with the following fields:

    1. StreetName
    2. County
    3. City
    4. Postal District
    5. Subdivision

    The second table has matching fields but has missing or erroneous information in the Subdivision field. In any one county, there is only a single street. Query on those two fields and you get the resulting subdivison. I want to update a 500,000 row table
    (the second table) with the correct subdivsion name. I have not figured out how to do that.

    Any help would be appreciated.

    Thanks in advance,

    Allan

    DB:2.90:Stumped Query zc

    Could you simplify it a bit more, i.e. like a query grid instead of a SQL statement.

    Karl has kindly told you how, but when we post an SQL statement like this all you have to do is open the query designer, switch to SQL view, and paste the statement into the window in place of what's there. You then just need to change the table and column
    (field) names to your actual ones, remembering that if spaces or other special characters have been included in table or column names (not recommended) they must be wrapped in square brackets [like this].

    In this case you can switch back to query design view if you wish, but with some more complex SQL statements, if you do switch to design view Access will screw things up, and at best the logic will be obscured, at worst the query will be too complex to open.
    Some queries can't be represented in design view at all.

  • RELEVANCY SCORE 2.89

    DB:2.89:Need To Find Out Duplicate Values In A Table/Chart. d3



    Hi,

    I have some table where we consider the three differen fields value which is in text and date. If I want to put a condition between all three like if all three fields are same for same passeger that means that ticket is duplicate. And I want to know the ticket number based on all three fields value only if the fields are matching twice or more than that. Could any one please let me know the solution.

    EX;_

    ( route Passenger Dateof departure) 1, that means all the three values are if matching for the same passenger and date of journey and itinary is same that means it should show the duplicate ticket number.

    Please help.

    Best,

    Shubham

    DB:2.89:Need To Find Out Duplicate Values In A Table/Chart. d3


    Hi,

    Can you attach a image of the solution that you need?

    Celambarasan

  • RELEVANCY SCORE 2.89

    DB:2.89:Portable Insert pz


    Hi
    I have two tables which get fields added over time as they are accessed by several apps for various reasons. Is there a portable way to insert rows from one to the other in a way that fields with matching names get data inserted and rest of fields in either
    table are ignored? This is to avoid changing code in my app every time fields are added to any of the tables by another user.
    Many Thanks
    Regards

    DB:2.89:Portable Insert pz

    Not really.
    If you do:
    INSERT table2(yourcol1, yourcol2, yourcol3, ...)
    SELECT yourcol1, yourcol2, yourcol3, ...
    FROM table1
    This will work if all columns in the target table that you leave out are nullable or have default values. But if there is a non-nullable column without a default value, you lose.
    For an UPDATE statement it's easier. Then you can list all your colunms and just ignore the rest.
    Steven showed you a way to build an INSERT statement with help of metadata, but nor this is portable. To wit, this assumes that the user has VIEW DEFINITION on the table, and this may not be the case.
    Overall, I'm reluctant to read metadata in application code.
    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

  • RELEVANCY SCORE 2.88

    DB:2.88:Sales Are Not Matching dd


    Hi All,

    How do i check why my sales are not matching in view.
    Even my fact table and my source table my sale is matching but in my view after joining these two tables
    sales are not matching.How should i check it Can anyone suggest.

    Thanks

    DB:2.88:Sales Are Not Matching dd

    Please give a little bit more information:
    * what is the DDL of the tables involved?
    * can you post some sample data and desired output?
    * what are the TSQL queries that you have written?
    My crystal ball is in the shop for repairs, so you need to be a little more specific.MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

  • RELEVANCY SCORE 2.88

    DB:2.88:Lookup Table df


    How to creative and access lookup table.
    I have two tables both having business name and state. I have to generate a report
    having same business name and state from both tables.
    But in table ST is like FL,TN,CA....
    in other table ST is like FLORIDA,California .....
    Because of this difference in where condition of sql state is not matching.
    To resolve this my friend suggest to create look up table having two column Abreviation and description.
    But i don't know how to use that look up table in my sql query where condition to match the state. Please help me.

  • RELEVANCY SCORE 2.88

    DB:2.88:Matching Attributes Across Tables 9k


    I have two tables, one a table linked to a Sharepoint list (that I dont have admin access to) and one that is a standard access table. I basically need the data within the table linked to the sharepoint list to be copied into the access table automatically.
     
    This would be done so that the fields of the access table match those of the sharepoint table and then extend it with further data fields. (because I cant change the fields in Sharepoint). I require that this extended version updates just as regularly (and instantly) as in the case of sharepoint table. As well as sharing primary keys across both tables. Is anyone aware of mechanisms for doing this?
     
    SharepointTable(Field1, Field2, Field3, Field4, Field5)
    AccessTable(Field1, Field2, Field3, Field4, Field5, Field6, Field7, Field8)
     
    Both shoulud update upon data input into the Sharepoint table.

    DB:2.88:Matching Attributes Across Tables 9k

     Ok that sounds like a way of doing it, is the timer control available to Access? Where can I find it? Basically a large part of my problem here is in the fact that when creating a new table and relationship you're normally able to enforce referential integrity between some chosen fields, allowing for these fields to match across both tables where the relationship is implemented. However the problem here  is that the use of the sharepoint linked table means that referential integrity options cannot be selected in access and as a result fields not forced to match across a linked tables fields.

  • RELEVANCY SCORE 2.88

    DB:2.88:Fuzzy Matching With Two Table In Sql Server 2000 as


    Hi,
    how can i do fuzzy matching with two table using sql server 2000. we do not have fuzzy grouping in version 2000.
    but i have to complete this with 2000 only.
    please do need full as soon as possible.
    Thanking You,

    DB:2.88:Fuzzy Matching With Two Table In Sql Server 2000 as

    Exactly what is not working? The function at
    https://sites.google.com/site/sqlblindman/fuzzysearchalgorithm
    or something else?
    If you want something that works exactly like the fuzzy-lookup thing in SSIS, you should use SSIS, if this so means that you will have to copy the tables over to a more recent version of SQL Server. Reinventing the SSIS wheel is likely to be expensive. Maybe
    more expensive than an upgrade...
    Then again, it lies in the nature of fuzzy that it is a little fuzzy what it means, and maybe the function from SqlBlindman could be good enough. But that also depends on your requirements and and data you want to match.
    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

  • RELEVANCY SCORE 2.88

    DB:2.88:Finding Unmatched Records Based On Two Fields ss


    Hi

    How can I find records in one table that are unmatched in the second table using two fields (from each table) as matching criteria?

    Thanks

    Regards

    DB:2.88:Finding Unmatched Records Based On Two Fields ss

    Try using the NOT EXISTS clause:
    SELECT *
    FROM Table1 T1
    WHERE NOT EXISTS
    (SELECT *
    FROM Table2 T2
    WHERE T2.Field1 = T1.Field1
    AND T2.Field2 = T1.Field2)
    HTH
    Henry

  • RELEVANCY SCORE 2.88

    DB:2.88:Making Selection In Two Mutually Exclusive Fields zp



    I have two fields which are mutually exclusive (value can be in either one and only one of them for a row). Is there a way by which I can make the selection in both of these fields at the same time?

    I am trying to have a variable event trigger which should make selection in both of the mutually exclusive fields so that I can have results matching conditions of both the fields (See chart in the attachment). Not sure whether it is possible or not.

    DB:2.88:Making Selection In Two Mutually Exclusive Fields zp


    Yes, that is possible using alternate states. See attached qvw.

  • RELEVANCY SCORE 2.88

    DB:2.88:Search In Two Fields cc



    Hello,

    I have two distinct tables. One table contains unique product fields and the other table contains fields which have the same products but which are spelt differently: I need to associate table 2 fields with the differently spelt products in Table 1:

    Table1:

    Product, Price

    Apple Ipad, 10

    Ipad Apple, 20

    APPLE IPAD 2, 20

    Trimmer, 4

    CD, 1

    CD 1, 5

    25 CD, 10

    Table2:

    Product Catalogue

    Ipad

    CD

    keyboard

    Samsung

    Find attached a demo application.

    Thank you in advance!

    DB:2.88:Search In Two Fields cc


    Thank you Celambarasan,

    Neat as well

  • RELEVANCY SCORE 2.87

    DB:2.87:How To Calculate The Difference Between Two Fields Of Different Lines In Automatic x8



    Hello

    I load into a table daily records matching counters printers. These counters represent the total number of pages printed. I would calculate the number of printed pages per day to display the graph of the number of printed pages per month.

    How I can do ?

    Thank you for your help

    Patrice

    DB:2.87:How To Calculate The Difference Between Two Fields Of Different Lines In Automatic x8


    Hello

    I load into a table daily records matching counters printers. These counters represent the total number of pages printed. I would calculate the number of printed pages per day to display the graph of the number of printed pages per month.

    How I can do ?

    Thank you for your help

    Patrice

  • RELEVANCY SCORE 2.87

    DB:2.87:Help Required To Fetch Records From A Table Where There Is A Matching Key And Write Into Another File In Sql Server... d1


    Hi All,
    I have a set of millions of records that I would need to compare it with a master table and select few additional fields (if the data field is NOT NULL) and write those two fields into another xls file.

    What would be the query/ command that I can use to WRITE the records that having matching key values from my input data with the records in the xls file? Immediate response would be very much appreciated.
    Regards

    DB:2.87:Help Required To Fetch Records From A Table Where There Is A Matching Key And Write Into Another File In Sql Server... d1

    Dear KaviSqlHelp
    Elaborate your requirement more clearly like TableA have millions of records and i need to compare with TableB etc..

    only then someone can propose a closer answer for your question.
    To simply save the records into excel, you can write click the result set and save rows as, also you can use SQL Server Import/Export wizard also.
    If both tables exist in the database itself, you can make join on the key columns to retrieve the columns from another master table.

    If you are not satisfied with my answer, please post more details about your requirement..

    Based on my assumtion you may need something like below, you may have tableA, tableB and col1,col2,col3 is your required field on which the data needs to be null
    Select col1,col2
    from tableA
    inner join TableB on TableA.id = TableB.id
    where col1 is null and col2 is null

    Working as a Senior Database Analyst Architect at Ministry of Higher Education in KSA

  • RELEVANCY SCORE 2.87

    DB:2.87:Lead Management cm



    I have two fields ( Lead No Opportunity No ) from same table field ( Table name is - CRMD_ORDERADM_H and fields name is GUID ). I am not getting linking table between this two ( Lead No Opportunity No ).

    DB:2.87:Lead Management cm


    Thanks Vijay,

    This FM solved my problem.

    Can you tell me if there is any standard report regarding document flow.

  • RELEVANCY SCORE 2.87

    DB:2.87:Lov kk


    Does anyone know how to do this?

    My table for Position contains two fields: Level and Description.
    Is there any way to use this table for a LOV having it display and return the same field Description? Otherwise I would have to save the Description in two fields.

    Thanks.

    Pat.

    DB:2.87:Lov kk

    Hi,

    You can use LOV as Popup and Select List in forms. Popup LOV (fetches first rowset) can display and return same column. In fact, I concatenate everywhere with other column or symbols as space.
    I think, all Popup LOV (not Popup Key LOV) could display and return same column.
    I hope that this would help.

    Konstantin

  • RELEVANCY SCORE 2.87

    DB:2.87:Enhance Business Agreement Extractor s1



    Hi

    I have to enhance Business Agreement Extractor in CRM to get fields get u2018Payment Typeu2019 and u2018Brandu2019 (both Z fields). The two fields are stored in table CRMM_BUAG_H as ZZBRAND and ZZPAY_TYPE

    Can anyone advice on the same? steps to be followed and what care should be taken

    Thanks

    Ishi

    DB:2.87:Enhance Business Agreement Extractor s1


    Hi

    I have to enhance Business Agreement Extractor in CRM to get fields get u2018Payment Typeu2019 and u2018Brandu2019 (both Z fields). The two fields are stored in table CRMM_BUAG_H as ZZBRAND and ZZPAY_TYPE

    Can anyone advice on the same? steps to be followed and what care should be taken

    Thanks

    Ishi

  • RELEVANCY SCORE 2.87

    DB:2.87:Remove/Hide A Field From The Left Slush Bucket ps



    Hi,

    I have a custom table that extends Task table and have created two new fields 'Category' and 'Subcategory' as reference fields in my custom table.

    While personalizing the form/list, I don't want the Task table fields with the same name (Category and subcategory) to be available in the left slush bucket for the selection since these fields are not being used. Is there a way to hide/remove these fields from the slush bucket so that user can't select these unused fields at all ?

    Thanks,

    Reach

    DB:2.87:Remove/Hide A Field From The Left Slush Bucket ps


    Another option is to use a script like this:

    var opt = $$("select#slush_left option[value=category]");
    gel('slush_left').remove(opt[0].index);

  • RELEVANCY SCORE 2.87

    DB:2.87:Doubt In Left Join-Urgent z9


    there are two tables..
    using left join,
    i have to fetch the last record of the table in the right(right side table)..
    at the same time ,the condition is that there are five records that match the left table,

    for eg,
    table 1(left) - has an ID 1
    and table 2(right) - has same ID existing in 5 rows.. but i have to fetch only the last matching record from the table 2.
    Also table 2 has unique column date.
    Kindly help me.............
    by johnny

    DB:2.87:Doubt In Left Join-Urgent z9

    LEFT JOIN examples:
    http://www.sqlusa.com/bestpractices/leftjoin/Kalman Toth SQL SERVER & BI TRAINING

  • RELEVANCY SCORE 2.86

    DB:2.86:Compare Files In Different Formats But Same Order 8f


    Java Developers,
    I have a serious problem here "Comparing two files"... in Java.
    We recieve 2 emails which talk about the same thing but not in the same format. one comes from my company and the other email comes from partner company. These 2 companies have their own standards and their own codes. so their emails do not match exactly.
    I should check whether the contents of these 2 files are same or not. Line by Line they r not at all same, entirely different formats as I mentioned earlier. but somewhere in between there will be same headers for eg: "Service Details" section . once u see that word in both the files then compare the fields under that section, check whether they r same or not. here also the fields are not the same, one says AB and another says '12' , I shud check whether they mean the same thing or not. We have a dictionary and a table which says AB ='12', Everyday we get around 200 sets of such matching emails. how to read them, how to process them and how to see whether they match or not.

    DB:2.86:Compare Files In Different Formats But Same Order 8f

    Also look at the java.util.regex package.

    Beyond that, "How do I write a program that does complex requirements statement?" is not an appropriate question for these forums. If you're totally stuck and don't know where to begin on that, then you're probably not qualified to do it. That's not intended as an insult, just a reality check.

  • RELEVANCY SCORE 2.86

    DB:2.86:Open Sql With Custom Fields In Standard Table cs



    Dear Experts,

    I am facing a problem in ABAP Open SQL with custom field in Standard table.

    I have added two custom fields in standard table. like below:

    Standard table : AUFM (Goods Movement for order)

    Custom fields:

    ZZID TYPE MB_LINE_ID

    ZZPID TYPE MB_PARENT_ID

    When I trigger the open SQL on this table, first time it give me wrong data in custom fields, and after that or immediately I trigger the same sql, it give me correct data in custom fields.

    I don't know what is the problem with custom fields.

    Please help.

    Thanks

    DB:2.86:Open Sql With Custom Fields In Standard Table cs


    If you remove the ZZ fields does your program behave correctly? If you are saying nothing has changed in the program except the addition of these fields to Internal table SQL and LOOP then it is going to be challenging..

    Regards

  • RELEVANCY SCORE 2.86

    DB:2.86:At New Command For Two Fields 3z



    Dear All,

    How to use AT NEW command in internal table for two fields.

    Warm Regards,

    N.Jain

    DB:2.86:At New Command For Two Fields 3z


    Hi

    See the following code. It is useful for u.

    DATA: BEGIN OF ty_batest,

    designation TYPE zba_test-designation,

    salary TYPE zba_test-salary,

    empno TYPE zba_test-empno,

    empname TYPE zba_test-empname,

    address TYPE zba_test-address,

    END OF ty_batest,

    it_batest LIKE TABLE OF ty_batest,

    wa_batest LIKE ty_batest.

    SELECT * FROM zba_test INTO CORRESPONDING FIELDS OF TABLE it_batest.

    SORT it_batest BY designation salary.

    LOOP AT it_batest INTO wa_batest.

    AT NEW designation.

    WRITE: / 'Designation :', wa_batest-designation,

    /(35) sy-uline.

    ENDAT.

    AT NEW salary.

    WRITE: / 'Salary : ', wa_batest-salary,

    / '----

    '.

    ENDAT.

    WRITE: / 'Emp Name : ', wa_batest-empname,

    / 'Emp Number : ', wa_batest-empno,

    / 'Designation : ', wa_batest-designation,

    / 'Address : ', wa_batest-address,

    / 'Salary : ', wa_batest-salary NO-ZERO .

    SKIP.

    ENDLOOP.

    Regards

    Bhuvana.

  • RELEVANCY SCORE 2.86

    DB:2.86:Setter Field Definitions Is Not Working zp



    Setter Field Definitions is not populating Source table fields and Matcher table fields in fuji release. Data Lookup and Record Matching Support plugin is already activated.Not sure what to do. Can some one please look into this and let me know If there is any solution for this.

    DB:2.86:Setter Field Definitions Is Not Working zp


    I explained the same in product issue, let us found the solution.

    https://community.servicenow.com/issues/1954

    Regards,

    Malli.

  • RELEVANCY SCORE 2.85

    DB:2.85:Repeat The Tables Of Same Dataset 19


    Hi i am having a dataset , i created two tables and dropped the some fields in 1st table and some fields in 2nd table.
    First,data for 1st table is coming.After that second table data is coming.But am UNABLE to repeat the data for the two tables parelally in the pages.
    Is there any custom code for this problem or any properties setting needed?
    Kiran Mandapaka

    DB:2.85:Repeat The Tables Of Same Dataset 19

    Yes, i want the repetition of two tables data in all pages of report.

    Kiran Mandapaka

  • RELEVANCY SCORE 2.85

    DB:2.85:Create A Separate Field/Table 19



    Dear Team,

    I want to create a new table/field by comparing fields in two different tables.

    Example

    Table I : User ID : Jebamalai.Pushparaj

    Table II : User ID : Jebamalai.Dass

    These two have same employee ID in both fields.

    I want to generate a table/field where User IDs are different for the same employee IDs

    Kindly guide me.

    Regards

    Jeba

    DB:2.85:Create A Separate Field/Table 19


    Dear Team,

    I want to create a new table/field by comparing fields in two different tables.

    Example

    Table I : User ID : Jebamalai.Pushparaj

    Table II : User ID : Jebamalai.Dass

    These two have same employee ID in both fields.

    I want to generate a table/field where User IDs are different for the same employee IDs

    Kindly guide me.

    Regards

    Jeba

  • RELEVANCY SCORE 2.85

    DB:2.85:Create A Separate Field/Table x9



    Dear Team,

    I want to create a new table/field by comparing fields in two different tables.

    Example

    Table I : User ID : Jebamalai.Pushparaj

    Table II : User ID : Jebamalai.Dass

    These two have same employee ID in both fields.

    I want to generate a table/field where User IDs are different for the same employee IDs

    Kindly guide me.

    Regards

    Jeba

    DB:2.85:Create A Separate Field/Table x9


    In Script

    Emp1:

    Load * Inline [

    EmpId,Nm

    1,Jebamalai.Pushparaj

    2,Raj ];

    Join(Emp1)

    Emp2:

    Load * Inline [

    EmpId,Nm1

    1,Jebamalai.Dass

    2,Raj ];

    Final:

    NoConcatenate

    Load EmpId, Nm, If(Nm Nm1,Nm1) Resident Emp1;

    Drop table Emp1;

  • RELEVANCY SCORE 2.85

    DB:2.85:Using Method Create_Dynamic_Table 8k



    Hi,

    I am using the above method (class cl_alv_table_create) to, whowouldathunkit, create an internal table: I have a construction of two nested WHILE loops to fill the internal table i_fcat which goes into the method so that it is not necessary to know how many tables (outer loop) and fields (inner loop) there are or even how many fields there are to any given table, it can vary.

    Now I have two problems with the internal table being generated by this method:

    1) The datatypes are always C, it seems: There is a SELECT which fetches some data from DB tables and puts it into this internal table. As long as it fetches only C-type fields, it works fine. As soon as it includes a D-type field like ERDAT, it fails because a D-type field cannot be squeezed into a C-type one.

    2) The method cannot work with two fields that have the same name; This is, however, quite commonplace between different SAP tables, so it is more than probable that my SELECT will in the long run include several fields that come from different tables, yet have the same name (you see I'm trying to make this program dynamic, the user will enter what tables and fields he wants in a dialog).

    Can anybody give me any hint as to how I can fix this? Can I perhaps use that method in a way so that it automatically defines the datatypes matching the DB object (f.e., if I have KNA1-ERDAT, that is datatype D - if the method were to take table_name and field_name and just define the datatype of the field to match that field, that would be perfect). I know there is a field "DATATYPE" in the line_type underlying the table_type LVC_T_FCAT that I use for i_fcat.

    Thanks a lot!

    Best regards,

    Sapperdapper

    DB:2.85:Using Method Create_Dynamic_Table 8k


    Hi all,

    thanks for all the help! I'll close this now as "Assumed answered". I am now using that method and I have fully dynamized the SELECT statement including the joins, so for now all is fine. Now comes testing and searching for a scenario where my code will not work...

    Thanks for all the help!

    Best regards,

    Sapperdapper

  • RELEVANCY SCORE 2.84

    DB:2.84:Display Field Value Matching jj



    Hi All,

    One of the Sub table contains two fields as Display Fields : Name(Default) and Identity .

    In Import manager I want Value Map the Identity field with One of the field in Source File.The problem is Map button is Disable for the Identity field but its enable for the Name Field?

    While creating identity Field in the Repository Am i Missing Anything? How can i enable the map button for Identity Field?

    DB:2.84:Display Field Value Matching jj


    Hi Priya,

    If I understood your problem, you want your hierarchy in taxonomy to look like as AA is your root node and 001, 002 are children.

    If this is the case then a very simple solution for that can be formatting your source file itself with two columns (Name and Identity). Then you will need to split only identity based on your name and map "Name" with "Name in destination in "Map fields" tab.

    Hope this solves your problem.

    Regards,

    Dheeraj.

  • RELEVANCY SCORE 2.84

    DB:2.84:Linq To Objects Join Question 8f


    Hello,
    I have two lists of custom objects that I need to return the non- matching objects for. So, essentially, these objects have three fields.
    dbname fieldname fieldtype
    So, obviously, I am comparing two tables in a sql server db. I have a populated list for each table. I currently have a new list of just those that are the same. Now, I need a two lists of fields where either the fieldname or fieldtype are unique in one of the tables or the other. Essentially, what I want would be like:select * from aleft join b on a.fieldname = b.fieldnamewhere b.fieldname = null
    Let me know if this does not make sense or you need more information.
    Thanks in advance! Ryan

  • RELEVANCY SCORE 2.84

    DB:2.84:Creating Tables xd


    I have two tables A B. Table A contains New patients and table B contains Revisit patients. Table B has most of the same fields as in table A except Revisit_date. I want that when I enter data in the OPD_ID field in table B all the data in the same row
    to it in Table A appear in all corresponding fields in table B. The OPD_ID field is a Primary key in table A but not in table B. I am not much experienced please help.

    Thank you for your kind help.

    Roderick

    DB:2.84:Creating Tables xd

    Thank you very much Sirs for the great help.
    My problem is solved

  • RELEVANCY SCORE 2.84

    DB:2.84:Urgent, With Attached File. On Pivot Table. 7k



    Hi all, see attached more clarity.

    firstly do check on the table layout on how it is jointed.

    I have two table of data name Throughput and TXIT.

    I would like to find the value (TEU) of Country (Country_Code) for tput and transit

    As you can see on table name : Throughput and Transit, the fields are basically matching to each other when i use Country Code and TXIT_Country_Code.

    However, my problem is I would like to combine this two onto one table (Table : Input code here)

    Can i do it on Dimension to make both of them join together? Since it carries the same meaning

    Thanks!

    DB:2.84:Urgent, With Attached File. On Pivot Table. 7k


    Okay let me rephrase.

    I tried your method which is to do construct a LEFT JOIN on the scripting part.

    However, the figures went out of sync as compare to previously.

    Kindly note that Throughput and Transit are two different database and we are trying to merge? Is it due to this reason and that is why the figures manipulated when I did a left join

  • RELEVANCY SCORE 2.84

    DB:2.84:Two Fields In A Drop Down. 8z



    I have a internal table which have two fields , and i have to show both these fields in the dropdown.

    so please provide your helpful answer for the same.

    Thanks in advance.

    Upendra.

  • RELEVANCY SCORE 2.84

    DB:2.84:Find Not Matching Rows In Two Tables In Script pz



    Hello All,

    i want to find the not matching rows in two different tables with same field numbers and name.

    for e.g:-

    Table A:

    Name Sale

    Prince 100

    Arun 200

    Table B:

    Name Sale

    Prince 100

    Arun 200

    Suresh 300

    So ans. should be suresh 300.

    Please Help me on this..

    Thanks Regards

    Prince Anand

    DB:2.84:Find Not Matching Rows In Two Tables In Script pz


    Hi,

    you can try this.

    Table:

    LOAD * INLINE [

    Name, Sale

    Prince, 100

    Arun, 200

    ]

    Where Name 'Prince'and Name 'Arun';

    add

    LOAD * INLINE [

    Name, Sale

    Prince, 100

    Arun, 200

    Suresh, 300

    ]

    Where Name 'Prince'and Name 'Arun';

  • RELEVANCY SCORE 2.84

    DB:2.84:Matching Infoobjects For Fields 9c



    Experts,

    I am creating a generic extractor on the table/view EKBE in R/3.

    How do I find the matching Business Content Infoobjects for those fields in R/3. Maybe I may need to create zinfoobjects too.

    Any ideas?

    Thanks,

    Raj

    DB:2.84:Matching Infoobjects For Fields 9c


    Hi

    1. In BW, Goto SE11 and give the table name as RSOSFIELDMAP.

    2. In the content screen of the table, Against FIELDNM - Give the field name and execute it.

    You will get the corresponding BW info object for the fields in the table RSOSFIELDMAP.

    Hope it helps.

    Regards

    Sadeesh

  • RELEVANCY SCORE 2.84

    DB:2.84:Does The Table Exist In Sap - Extract Structure Corresponding To The Table? 7p



    Hi, gurus here.

    It seems the extract structure MCAFVG which is corresponding to table PLPO (MCAFVG includes almost all important fields of PLPO).

    So is there any table in SAP that I can find all the matching-relationship between extract structure and table?

    Thanks, for a lot.

  • RELEVANCY SCORE 2.84

    DB:2.84:Table Maintanence Generator : In This Some Fields Are Mising xm



    Hi ,

    I added two fields for the exisitng custom table .and regenerated the Table maint generator...but the two extra field which i recently added were not gettig displayed in the TMgenerator .

    any adivse on the same .

    thanks

    DB:2.84:Table Maintanence Generator : In This Some Fields Are Mising xm


    Hello Ramreddy,

    did you resolve then this problem concerning the table maintanance generator ?

    I'm having the same problem and I tried out all the options as you as well but without success.

    Please answer me if you have any solutions.

    Thank you in advance.

  • RELEVANCY SCORE 2.84

    DB:2.84:Find Matching Records From Two Tables, Useing Three Key Fields, Then Replace Two Fields In Table1 From Table2 mp


    I have two tables - table1 and table2 -that have the exact same schema. There are three fields that can be used to compare the data of the two tables, field1, field2, and field3. When there are matching rows in the two tables (table1.field1/2/3 = table2.field1/2/3)
    I want toreplace table1.field4 withtable2.field4 and replace table1.field5 with table2.field5.
    I have worked with the query but have come up with goobly goop. I would appreciate any help. Thanks.

    DB:2.84:Find Matching Records From Two Tables, Useing Three Key Fields, Then Replace Two Fields In Table1 From Table2 mp

    UPdate - I never tried either of the two proposed answers. My requirements changed from syncing and Updating the table to understanding why there were differences. So I needed to find the differences between the data of the two tables. I first copied my
    two table records to CSV file and used Beyond Compare to highlight the differences in the data. This actually worked well - Beyond Compare is really good, I use it all the time for everything - but it was slow for my tables with approximately 31k rows. Then
    I got Red Gate SQL Data Compare and it was a breeze to compare the data and find the differences.

    Thank you for the posts to an question. I will keep the answers to use in the future.

  • RELEVANCY SCORE 2.83

    DB:2.83:Filter Option In Matching Fields zk



    Hi,

    When right click on Matching fields, there is Filter in import Manager. Can anyone let me know, how that Filter related to Matching Fields records please?

    Thanks.

    Regards,

    Lahari

    DB:2.83:Filter Option In Matching Fields zk


    Hi Lahari,

    Filtering narrows down both the source and destination record sets, but with slightly different effects, as follows:

    Source Side i.e. In Match records tab narrows down the set of source records so that those that do not meet the filtering criteria can be excluded from the import.

    Destination i.e. In matching fields tab narrows down the set of destination records, excluding those that do not meet the filtering criteria from record matching.

    The filter is inclusive, and expands the set of records on which you can perform import operations to those that do meet the filtering criteria.

    For more information please refer to the below link

    [http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm]

    Go to Matching Records - Records Matching Operations - Setting the Record Filtering Criteria

    Regards,

    Jitesh Talreja

  • RELEVANCY SCORE 2.83

    DB:2.83:Compare Two Tables Having Different Number Of Rows Based On 2 Columns a7


    Hi,

    I am having two tables table a having field1, field2 and table b having fields field1 and field2.
    I want those records from table a in which field1 of table a is not matching to field1 of table b and field2 of table b not matching to field2 of table b, but i also want the bifurcation of records as whether field 1 is not matching, field 2 is not matching or both fields 1 2 are not matching.

    e.g.
    table a table b
    field1 field2 field1 field2
    ------ -------- --------- ---------

    1 6 12 5

    2 5 1 9

    13 51 13 51

    45 31 99 121

    33 45

    In this case my output should be

    table a

    field1 field2 Mtchng_Field

    1 6 Field 2 not mtchng

    2 5 Field 1 not mtchng

    45 31 Feild1 and Field2 both not matching

    How would i get my result in the required format.

    DB:2.83:Compare Two Tables Having Different Number Of Rows Based On 2 Columns a7

    maybe something like

    select t1.n1, t1.n2,
    decode(max(decode(t2.n1,t1.n1,2,0))+
    max(decode(t2.n2,t1.n2,1,0)),
    0,'No match',1,'F1 does not match',2,'F2 does not match',3,'Both matches') X
    from t1,t2 group by t1.n1,t1.n2

    N1 N2 X
    ---------- ---------- -----------------
    1 6 F2 does not match
    45 31 No match
    2 5 F1 does not match
    33 45 No match
    13 51 Both matches

  • RELEVANCY SCORE 2.83

    DB:2.83:Selections m3



    Hi

    I have an expression that matchies two table and I want it to return only the matching rows, but at the moment it is returning even those that are not matching, can anyone please help?

    Please see the attachment for clarity, I want Data in the Color Coding Table to look the same as in the Total amount, with out changing the tables

    Regards

    Edzi

    DB:2.83:Selections m3


    Thanks

    Now I get you, Instead of xName and xBenchmarkName expressions, you replaced them with calculated Dimensions and The TotalAmount Background colour only calculates the weather TotalAmount is less than Benchmark.

    Thanks again.

    Regards

    Edzi