Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Exporting multiple Data columns from FDMEE

Hi,
FDMEE allows exporting data from planning in csv file but unfortunately it allows only one cell to be exported per row.
E.g
like this.
I want to extract multiple cells per row.
E.g.
How can i achieve this?
Is there a workaround? can i do that using mapping scripts etc?
Regards
Answers
-
Hi JanGLi,
In import format, use Expression that tells where your amount column is. In the screen shot below my amount column for Jan to Dec is in column 9 to 20. You can ignore the ;NZP it is just an expression to make sure the customer can load "0" value instead of ignoring it.
Here is the step by step:
-
I can only achieve this if my source is file?
Regards
-
Hi , you mentioned CSV in your first post? CSV is considered as File for FDMEE.
-
Yes i did.
But i want to export data in CSV file, not import.
Regards
-
So I take it you are using a custom target application, if you run just an import from source the export file generated in the /data directory will be in column format, is that file good enough or do you require mappings applied?
Cheers
John