@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?
Compare two data columns with different time stamp columns

William
41
Reputation points
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.
Accepted answer
-
Lz._ 8,801 Reputation points
2021-04-29T08:37:42.193+00:00
2 additional answers
Sort by: Most helpful
-
Lz._ 8,801 Reputation points
2021-04-15T18:03:36.827+00:00 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
-
Lz._ 8,801 Reputation points
2021-04-26T21:18:00.983+00:00