Forum Discussion
tgjones43
Helper IV
Helper IVConditional merge of two tables
Hi all I have 2 tables that I would like to merge into 1 but I can't figure out how to do it. The 2 tables below show a simplified snippet of data. Table 1 has values for several parameters (not ...
BA_Pete
Super User
Super UserHi tgjones43 ,
If you repeat the logic that you used to put the "Y" in Table1, but kind of in reverse, you can create a new column in Table2 that converts the actual read time to the nearest quarter hour.
From here, you can just merge on Table1[Date]&[Time] = Table2[Date]&[AdjustedTime]
Pete