[SOLVED] Cant join two tables

bzavala

Hi! I want to make a join between two tables, but the result looks like there's any value in common in the key attribute.  I already checked that key attributes were of the same type (polynomial) and both are attributes. I dont know what else may be the problem. Thanks in advance.

This is my code:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="6.4.000">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="6.4.000" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="read_csv" compatibility="6.4.000" expanded="true" height="60" name="Read CSV (5)" width="90" x="45" y="75">
        <parameter key="csv_file" value="C:\Users\BI\Desktop\Beatriz\Cuantificacion quiebres\local 2029\Datos 2\2016.csv"/>
        <parameter key="column_separators" value=","/>
        <parameter key="first_row_as_names" value="false"/>
        <list key="annotations">
          <parameter key="0" value="Name"/>

JEdward

For some reason the code seems to be chopped off on my end so I cant see the full process. 

However, are you definitely sure there are common matches between the attributes? 

There might be little things that make a difference between the examplesets for instance:

Set 1	Set 2
hello	Hello
hello	hello

In the cases above the word "hello" doesn't match with either of the polynominal values in Set 2. 

• First because "Hello" contains a capital so isn't an exact match, use a Generate Attributes operator first with "lower(attName)"
• Second because "hello " contains a sneaky trailing space which again means it's not an exact match, use a Trim operator to fix this.

Does your data contain anything like this which would mean there are no matches? 

bzavala

I applied trim operator to my tables and it worked!!! thanks you very much!!