How to get next item in list of Numbers?

Artem.shchaulov

Hello.

 

There is a list of numbers (not number list) - 1,2,3 etc.

There are no other dimensions except this list of numbers. No Time dimension.

There are 2 line item: Lead Column and Cost Centres

Could I put Cost centers to every row, like in a picture below?

 

 

 

 

 

 

 

 

 

 

 

Thanks for Help.

PaulRitner

Hi,

 

Looks like you are loading a transaction report, and are trying to associate the subtotal line (Cost Center) with the detail lines above it.

 

There could be a way to do this using a combination of a Textlist string and Find, however, textlist has a 10,000 character limit, so it would only work on a very small list.

 

I'm mulling this over, but it might be easier to adjust the data in Excel (i.e. an excel formula could find the cost center rows and assign them above), or work with the source system admin to get a more usable dataset (longer term solution, might take some time to coordinate that).

 

I'll let you know if I come up with anything, I'm intrigued....!