Forum Discussion
Dynamic List.Repeat
Dear all,
I have the following set of data:
I used the following formula to get:
ColToMove = HeadersToShift,
MovedCol = List.Repeat({null},2)&ColToMove
I tried to make this change dynamic based on the values I get in the Column Rows To ShiftDown
ColToMove = HeadersToShift,
MovedCol = List.Repeat({null},Rows_To_ShiftDown)&ColToMove
But I got this error:
Expression.Error: We cannot convert a value of type Table to type Number.
Could you help?
Thanks.
because Rows_To_ShiftDown is a table, not a single number — but List.Repeat expects a number as its second argument (how many times to repeat).
maybe you can use the following formula instead
ShiftCount = Rows_To_ShiftDown{0}[YourColumnName],
MovedCol = List.Repeat({null}, ShiftCount) & ColToMove
6 Replies
because Rows_To_ShiftDown is a table, not a single number — but List.Repeat expects a number as its second argument (how many times to repeat).
maybe you can use the following formula instead
ShiftCount = Rows_To_ShiftDown{0}[YourColumnName],
MovedCol = List.Repeat({null}, ShiftCount) & ColToMoveHello
How to start this repetition from the second element of the column and not from the first?
Thanks.
To just answer your question: the error is because Rows_To_ShiftDown is a table, not a number.
Perhaps you could complete your question to get better suggestions.
I did not get your answer.
I knew the reason, but I would like to understand how to fix the issue.
I am not so familiar with PQ unfortunately. 🙂
Thanks a lot.
Hi Mic1979 ,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,Chaithanya
Hello v-kathullac
sorry for the delay, I just had the opportunity to test the solution.
Accepted, many thanks for your great support.
