nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Row Count as an ID for ADO

Olek P

Hi all,

I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO?

Basically how would I do row_number() in SQL?

Accepted answers

JeffreyG

@Olek P Currently, I do not believe this is something ADO can accomplish. There are no native ROW() functions, nor can ADO formulae reference values / cumulate across different rows.

You may be able to use the HASH() function to generate a unique ID, and import it into a temporary staging production list & module in Anaplan. You could then use logic to link it to a cumulative row count via logic and an additional import, but not sure the use case and if that complexity would be feasible for what you are trying to accomplish.

All comments

JeffreyG

Hi @Olek P - Is the intent here just to create a unique ID, or does this need to specifically be a row count? If the former, you could use the HASH() function in ADO to generate a unique identifier.

Olek P

@JeffreyG, thanks for getting back. I would be looking for row count, is this possible?

JeffreyG

@Olek P Currently, I do not believe this is something ADO can accomplish. There are no native ROW() functions, nor can ADO formulae reference values / cumulate across different rows.

Kartik

One thing to consider is whether the row number needs to remain consistent across different file loads. If the source file can change its row order, a row-based ID could potentially point to a different record on the next load. In that case, using HASH() on a combination of fields might be more reliable. It would be interesting to know what the downstream use case is for needing the sequential row count specifically.

Quick Links

Can you help?

Unanswered questions

Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Anaplan AI Actions
The July and August releases added several useful capabilities to Anaplan AI, including the ability to create and retrieve saved views and create list import actions. It would be valuable to extend these capabilities to support the full end-to-end user story: creating a saved view and using it as the source for an import…
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.