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?
@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.
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.
@JeffreyG, thanks for getting back. I would be looking for row count, is this possible?
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.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
