Forum Discussion
Adding a column or table with skipped rows
Hi! I managed to check how many "Nro. Comprob." rows are getting skipped. Now I'm trying to get which rows are getting skipped and I would like to add them to a new column or a new table, b...
wdx223_Daniel
Community Champion
Community Championassume the Nro. Comprob column is the forth column, then try this
NewStep=#table(Table.ColumnNames(PreviousStepName)&{"Skipped rows"},List.Accumulate(Table.ToRows(PreviousStepName),{{},null},(x,y)=>{x{0}&{y&{y{3}-x{1}+1}},y{3}}){0})
Thanks for your response! I'll try it!