Forum Discussion

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
5 years ago
Solved

Error at first value while using list.generate in power query

I am trying to extract the value from list and append data for each value in list in a loop.   Using list.Generator to achieve this task, problem I am facing here is for first value in list always ...
Need Help
Show and Tell
Tips and Tricks
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, siva_powerbi , I think the glitch lies in here

    () => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing)]

    try changing it to

    () => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing())]
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, siva_powerbi , I think the glitch lies in here

() => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing)]

try changing it to

() => [i=0,x= Table.FromList(#"Col Names",Splitter.SplitByNothing())]
  • siva_powerbi's avatar
    siva_powerbi
    Icon for Helper IV rankHelper IV
    5 years ago

    Thanks for the reply.

     

    Error gone but new issue, First I am seeing a TABLE retuned with full set of values in the list.

     

     

    Can you please help why this change?