Forum Discussion

Hansolu's avatar
Hansolu
Helper 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

     



mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

Hi Hansolu 

Can you please try the below steps to get your requirement ?

1. Create index column from 0 

2. Create custome column using below code

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

 

After creating custom col if index col is not required then you can remove it.


If this answers your questions, kindly accept it as a solution and give kudos.