FDM Data Load format
649879Oct 28 2008 — edited Oct 29 2008Hi All,
I am new to FDM. I have some clarifications in the FDM data load format.
Please let me know,
1) what is the difference in the below two formats ?
2) How to ignore the first 7 rows while loading into FDM (in format1) ?
3) Does the character '!' means comment - FDM will ignore that ?
4) Can we automate data load in FDM ?
Format1: (.txt format)
-----------------------------------------------
!SCENARIO=ACTUAL
!PERIOD=SEPTEMBER
!YEAR=2008
!VIEW=YTD
!VALUE=USD
!COLUMN_ORDER=ENTITY,ACCOUNT,ICP,CUSTOM1,CUSTOM2,CUSTOM3,CUSTOM4,AMOUNT
!DATA
US,1000,101,[none],[none],[none],[none],1000.00
Format2 (.txt format)
------------------------------------------------
Actual,September,2008,YTD,EUR,Europe,1001,110,[none],[none],[none],[none],5000.00
Thanks,
Siva