Compare two data columns with different time stamp columns

Question

I am trying to compare two data columns with different time stamp columns. The first columns look like this:

The second columns look like this:

And i want to compare them like this:

I have thousands rows in my columns to compare, so an answer to this problem would really help me.

Answer 1

@William
I didn't change anything to your data, I took what I found in sheet Ark1, that's it.
In this updated version I copied/pasted the values from sheet Ark2 into Tabell1 and reformatted the 4 columns
Is this OK now?

Answer 2

Hi @William

2 columns named "Time" means those columns are necessarily in different tables, what I assumed below:

let  
// Tables for demo  
    Table1 = Table.FromRows(  
        {{#time(0,0,0),"A"},{#time(2,0,0),"B"},{#time(3,0,0),"C"},  
         {#time(5,0,0),"D"},{#time(6,0,0),"Z"}},  
        type table [Time=time, Column1=text]  
    ),  
    Table2 = Table.FromRows(  
        {{#time(0,0,0),"E"},{#time(1,0,0),"F"},{#time(2,0,0),"G"},  
        {#time(3,0,0),"H"},{#time(4,0,0),"I"},{#time(5,0,0),"J"}},  
        type table [Time=time, Column2=text]  
    ),  
//  
    JoinedTables = Table.NestedJoin(  
        Table1,"Time",  
        Table2,"Time",  
        "Tbl2", JoinKind.Inner // or JoinKind.LeftOuter depend. on the expected result  
    ),  
    Expanded = Table.ExpandTableColumn(JoinedTables, "Tbl2", {"Column2"}, {"Column3"})  
in  
    Expanded  

Answer 3

@William . In sheet Ark 1