Data Copy for more than 10k rows of a single line item.
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
@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 functions2
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)
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 sustainably1
If you need a single value for that line item, you can just hard code that value into the formula and then delete it.1
@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!!