Export Inquiry

Hi,

Hi,

I would like to ask if Anaplan has an option to export data in this format? The client requirement is that we can export data in this format so they can load it to another system. I have tried the export definition txt file and it is not the same.

Appreciate the assistance

Regards,

Tags

Importing and Exporting Data

Data Integration

Accepted answers

Hi @Jsdeloria21

I don't believe this is possible with the standard export formats.

A work-a-round might be to create a custom module and then to concantenate the line items into one line item by converting them to text and then include the spaces with horizontal lines inbetween them, however this would be limited to the number of characters within the line item.

I hope this helps!

Also I would be interested to see if anyone has a better solution?

Thanks,

Usman

As @usman.zia says, no, this is not currently possible, but would be a good enhancement, so post the use case on the idea exchange

https://community.anaplan.com/t5/Idea-Exchange/idb-p/AnaplanIdeas

Also, if you so go down the text concatenation route, please take note of the efficient way to join text, which is outlined here

https://community.anaplan.com/t5/Best-Practices/Formula-Optimization-in-Anaplan/ta-p/41663

Cheers

David

All comments

Hi @Jsdeloria21

I don't believe this is possible with the standard export formats.

A work-a-round might be to create a custom module and then to concantenate the line items into one line item by converting them to text and then include the spaces with horizontal lines inbetween them, however this would be limited to the number of characters within the line item.

I hope this helps!

Also I would be interested to see if anyone has a better solution?

Thanks,

Usman

As @usman.zia says, no, this is not currently possible, but would be a good enhancement, so post the use case on the idea exchange

https://community.anaplan.com/t5/Idea-Exchange/idb-p/AnaplanIdeas

Also, if you so go down the text concatenation route, please take note of the efficient way to join text, which is outlined here

https://community.anaplan.com/t5/Best-Practices/Formula-Optimization-in-Anaplan/ta-p/41663

Cheers

David

Quick Links

Can you help?

Unanswered questions

Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…