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 just help correct the syntactic error in that expression; but what is the expected result in the first row?

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

    Expected output is first row should be

    Table.Distinct(Table.FromList(Sheet2 (2)[Test1], Splitter.SplitByNothing(), null, null, ExtraValues.Error))

    instead of TABLE.

    Thanks