Data Copy for more than 10k rows of a single line item.

muizzsk9890

Hi Community,

What are the possible ways to load a single date into (Date Formatted) line item which has more than 10000 records.

I know the few drills which is

1) Importing manually by creating a csv of that single line item with multiple rows

2) Copy down method (applicable only for 10k rows only)

Does anyone have any possible way except above? Any Suggestion will be helpful

Regards,

Accepted answers

KirillKuznetsov

@rishabh01nice suggesion if you don't have the filtered data to be loaded with values.

@muizzsk9890If you need more control over the cells which you want to load this values - you can combine filters and Copy Down/Copy Across functions

ryan_kohn

If it is a single date that applies to every list item, then you should be storing that date in a System module and using a formula in your line item to reference the line item in the System module. This is in line with the best practice to use System modules (rule 5.07-05) .

You can read more about System modules vs other types of modules here: https://community.anaplan.com/t5/Best-Practices/Best-practices-for-module-design/ta-p/35993

Additionally, I would suggest reviewing these two microlessons:

Creating System Modules (3 min)
Build a Time System Module (4 min)

clarissa

I prefer this solution rather than the one that was chosen (hard code in formula, then delete) as the solution. If you add more records to the list or if you need to change what that date is, you can manage it in a system module more sustainably

All comments

rishabh01

If you need a single value for that line item, you can just hard code that value into the formula and then delete it.

KirillKuznetsov

@rishabh01nice suggesion if you don't have the filtered data to be loaded with values.

@muizzsk9890If you need more control over the cells which you want to load this values - you can combine filters and Copy Down/Copy Across functions

muizzsk9890

@rishabh01 Thanks for the idea!! It worked on our test model.

@KirillKuznetsov Thanks for your suggestion. But needed to clarify that whether your method is limited to 10k values only? Because I have a data of almost 1M+ entries which need to be assigned a single date. Please let us know if any other approach is possible!!

Thanks a lot both of you!!

Regards,

ryan_kohn

You can read more about System modules vs other types of modules here: https://community.anaplan.com/t5/Best-Practices/Best-practices-for-module-design/ta-p/35993

Additionally, I would suggest reviewing these two microlessons:

Creating System Modules (3 min)
Build a Time System Module (4 min)

clarissa

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…