Sort Time Error

[Anonymous]

Could use some help with this error message - Not sure what the issue is besides what the error message is saying. 

Receiving this error: 

"An error occurred in the ‘SortTime’ query. Expression.Error: 5 arguments were passed to a function which expects between 2 and 4.
Details:
Pattern=
Arguments=[List]"

This is the code:

= Table.NestedJoin(DimTime1, {"Time_HalfHour_RangeEnd_TXT"}, SortTime, {"Time_HalfHour_RangeEnd_TXT"}, "SortTime", JoinKind.LeftOuter)

[Anonymous]

Yeah, the problem is somewhere in your SortTime query, your Join Step is right on. Just go to the SortTime query and follow the steps until the error appears, that's what you need to fix.

--Nate 

[Anonymous]

Hi @Anonymous ,

I doubt that the error is caused by this line. The able.NestedJoin function takes between 5 and 7 arguments, so the error description does not match what would happen. Could you please check what your DimTime1 and SortTime produce? This looks like a place where the error manifested itself, but not where it is actually made.

Kind regards,

JB