Forum Discussion

Hansolu's avatar
Hansolu
Icon for Helper II rankHelper II
1 year ago
Solved

Add a paired index column

Hi,  I am struggeling to add a paired index column into a nested table in PQ   I know how to add an index in the nested table like 1,2,3,4,5,.... what i do need to add is another column lik 1,1,2...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    Hansolu 

    First, add a simple index column starting with zero:

    Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type)


    then the second one

    Number.IntegerDivide([Index], 2) + 1


    Result

     



Hansolu's avatar
Hansolu
Icon for Helper II rankHelper II
1 year ago

Hi, 

thanks both of you, same solution, works great

Actually I was thinking, must be something easy, I just took the wrong turns in my trials

Thanks for the help