I want to join the table

[Paknanarn23]

I have data from these 2 tables. By using RunTime Join with table ST, I have already created the Key as shown in the picture, but the results show duplicate data. What should I do?

[rubenmarin]

Hi, if any of the tables has more than ne row for the same FinishMachine, EquipmentNo and KCEPart, it will crete duplicates, some of the options are:

- Add some field to the key that has a unique value per row in each table.

- Assign values using mapping tables, wich doesn't creates duplicates.

- LOAD using GROUP BY in the table with duplicated keys to merge rows in only one row per key, like doing a sum of working time.

[Paknanarn23]

Hi, Can you show me an example?

[rubenmarin]

Hi, Is there a table that has more than one row for the same FinishMachine, EquipmentNo and KCEPart? Wich result do you expect?

[Paknanarn23]

None. There are only these 2 tables that I want to join.

[StarinieriG]

Hello,

try to use the function floor before to use date

ex. Date(floor(FIELD),'YYYY-MM-DD'))