跳到主内容

搜索

搜索

2 excel file join not showing all records

评论

3 条评论

  • Avatar
    Peter Thane

    Hi Bilal,

    If you just link the second table to a BarTender label and browse the records do all 698 still show up or only 558?

    I have seen issues before where data is not appearing where you have a mix of numeric and alphanumeric characters but where all the numbers are near the top. No matter how you format the data in Excel the ODBC driver seems to only look at the 1st few records and decides it is a fully numeric column and so any alpha only or alphanumeric items just appear blank in the table. To get round this i would just add a new record at the top of the table with a value of "dummy" in all the fields so that the ODBC driver then sees the alpha characters

    Pete. 

    0
  • Avatar
    Bilal Aslam

    Hello,

    Thanks for your reply, I have 698 lines and when i select only 1 file it show me all 698 records, but, when i join both files it should gives me 698 records connections with the other file, but in record picker I see only 585 records, and i also noted that it shows me only 10 recods of  S1R positions, instead of 29 records!

    I have tried to do what you said but seems not working!

    I don't know why 

    Thanks for your reply again

    0
  • Avatar
    Peter Thane

    Not sure, I take you have checked the data to make sure there is an exact match between the two fields you are comparing and there are no spurious (or none printable) characters in the fields?

    0

请先登录再写评论。