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

muizzsk9890
Frequent Contributor

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

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,

Muizz S.
3 ACCEPTED SOLUTIONS

Accepted Solutions
KirillKuznetsov
Certified Master Anaplanner

@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

Regards, Kirill Kuznetsov
Advanced, LLC

View solution in original post

ryan_kohn
Certified Master Anaplanner

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:

 

View solution in original post

clarissa
Certified Master Anaplanner

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

View solution in original post

5 REPLIES 5
rishabh01
Frequent Contributor

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
Certified Master Anaplanner

@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

Regards, Kirill Kuznetsov
Advanced, LLC
muizzsk9890
Frequent Contributor

@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,

Muizz S.
ryan_kohn
Certified Master Anaplanner

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:

 

clarissa
Certified Master Anaplanner

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