You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Data Export to File Pivot: Columns missing due to no data for the specific member

    in Planning 2 comments

    In Data Management/Data Integration, I have a data extract process that utilizes the Data Export to File method to pivot Accounts as column headers (5 Accounts in total). A groovy script runs 3 years of data.

    My issue arises when one of those years does not have any data for 1 of those 5 pivoted Accounts, causing the resulting extract file to be different than the other 2 years' extract files. I need to ensure that all files contain all 5 Accounts as columns (otherwise the format of the 3 files will be different), regardless of if there is data or not. Is this possible? Any thoughts on an approach to accomplish this?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!