Results 1 to 4 of 4

Thread: Define a link between 2 files, where the linked fields must match with each other by their first 10 characters

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Athens - Greece
    Posts
    292

    Post Define a link between 2 files, where the linked fields must match with each other by their first 10 characters

    Hello,

    I have 2 SQL tables A and B.
    Field 1 from table A is a 15 characters string field.
    Field 1 from table B is a 25 characters string field.

    Both tables have records matching by their 1st 10 characters
    Like so:

    Table A Field 1 Table B Field 1 Table B Field 2
    AAAAAAAAAA12345 AAAAAAAAAA987874565645 100
    BBBBBBBBBB12345 AAAAAAAAAA12377660011 100
    CCCCCCCCCC12345 BBBBBBBBBB66120022334 200
    DDDDDDDDDD12345 CCCCCCCCCC12377660012 300
    DDDDDDDDDD12377660013 400
    DDDDDDDDDD12377660014 400
    DDDDDDDDDD12377660015 400













    I need to create a report based on table A, but I also need Table B Field2 column (always the same for all Table B records starting with the same 10 characters)

    How can we create such a link in CR11? (reports are using ODBC to connect to SQL tables)
    I have tried all the combinations possible for the link, report always comes up empty.

    Basically, I think can filter the records from the selectionformula (Left(TableA Field1,10)=Left(TableB Field1,10)), but it seems the link (outer join) from Table A to table B is not working as I expect.
    Any ideas on how that link should be defined?

    Thank you
    Yannis
    Last edited by Yannis; 25-Jul-2019 at 04:01 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •