Combine nearly identical tables

[Larsus123]

Hey there,

I am trying to combine two tables in the following way:

Table 1:

Timestamp | Step

1 | a
2 | a
3 | b
4 | c

Reference Table:

Timestamp | Step

1 | a
2 | a
3 | a
4 | b
5 | c

Now change Table 1 to Target table:

Timestamp | Step

1 | a
2 | a
4 | b
5 | c

I tried every kind of join and reference filter, but it didn’t work.

Do you know a solution?

Best regards and thank you,
Lars

[HansS]

Hi Lars @Larsus123

Are you sure your example tables are ok? Because I don’t get it why 3|b is in table 1, not in the reference table (3|a) and not in your result table, but 4|c is also in your table 1, not in the reference table (4|b), but 4|b is in the final table. Can you explain more logic, does order matter?

[Larsus123]

Hello Hans,

Thank you very much for your response.

Let’s assume, we have Test Person 1 (Table 1). This person should have done 3x Step a, 1x Step b and 1x Step c. But he did Step a only 2x. Consequently, the following steps got the wrong timestamp.

The final table should show, that Test Person 1 missed 1x Step a (Time Stamp 3) but did the other steps b and c (Timestamps 4 and 5). The timestamps in the final table should be in the right order, so 1 2 4 5.

Did I explain it in an understandable way?

Best regards and thank you,
Lars

[HansS]

Hi @Larsus123

I hope I understood your problem. The result is this workflow.

.
I think you should check if it gives you the results you expect and if this solution works if you have to check multiple tables. So hope this helps. combine_2_tables.knwf (82.3 KB)
gr. Hans

[armingrudd]

Hi,

If I’m not missing anything, then I think this workflow would do what you want:

missing_step.knwf (324.1 KB)

[Larsus123]

Thank you very much Hans and Armin. I am going to try both solutions in my work.