1. User's Guide
  2. Managing Data
  3. Extracting Data
  4. Flat File Extract Options

Flat File Extract Options

When you extract members in a flat file format, you can select whether to include a header for the file.

Example: Flat File with Header

Scenario=Actual
Year=2014
Period=[Year]
View=YTD
Entity=CORP_OPS
Parent=GROUP
Value=[Parent Total]
Possible Duplicated Records=No
SalesIC;CHINA;[None];[None];[None];[None];100000
SalesIC;CHINA;[None];AllCustom2;[None];[None];100000
Scenario=Actual
Year=2014
Period=[Year]
View=Periodic
Entity=CORP_OPS
Parent=GROUP
Value=[Parent Total]
Possible Duplicated Records=No
SalesIC;CHINA;[None];[None];[None];[None];100000
SalesIC;CHINA;[None];AllCustom2;[None];[None];100000

Example: Flat File No Header

!Data
Actual;2014;[Year];YTD;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];[None];[None];[None];100000 
Actual;2014;[Year];YTD;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];AllCustom2;[None];[None];100000
Actual;2014;[Year];Periodic;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];[None];[None];[None];100000
Actual;2014;[Year];Periodic;GROUP.CORP_OPS;[Parent Total];SalesIC;CHINA;[None];AllCustom2;[None];[None];100000