Export Inquiry

Jsdeloria21

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,

usman.zia

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

DavidSmith

@Jsdeloria21 

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