Forum Discussion
Using List.Contains causing long load time
In each table/query where you use the list, add a step up front that buffers your list with
BufferedList = List.Buffer(InServiceXIDs)
Then use BufferedList in place of InServiceXIDs in your later query step(s). Also, you don't need to have "=true" after List.Contains.
Pat
Try this:
(List.Contains(List.Buffer(InServiceXIDs_List),[unit_id])=true))"
--Nate
Solution SageIn each table/query where you use the list, add a step up front that buffers your list with
BufferedList = List.Buffer(InServiceXIDs)
Then use BufferedList in place of InServiceXIDs in your later query step(s). Also, you don't need to have "=true" after List.Contains.
Pat
Thank you for the info and feedback. I need to start doing exactly what you've done here with using the defined variables. I've not turned that to a habbit yet! And I was wondering about using "true", wasn't sure that I needed it, but the tutorial I referenced had it, so here I am! haa. Thanks again.
worked like magic, thanks
