Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Data Export to File Pivot: Columns missing due to no data for the specific member — Cloud Customer Connect
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

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

Accepted answer
12
Views
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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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