Support Article
Unwanted identifier information at the end of the extracted file
SA-45360
Summary
There is an unwanted identifier at the end of each generated extract file for Business Intelligence Exchange (BIX) 7.1.8.
Looking for a way to remove the pxExtractIdentifier and pxExtractDateTime columns from the extract files.
Error Messages
Not Applicable
Steps to Reproduce
- Extract using BIX.
- Note unwanted columns and footer.
Root Cause
This is the default BIX behavior.
Resolution
Here’s the explanation for the reported behavior:
Check BIX user guide and look for ‘Unique run identifier’ topic for more information.
Always do post processing on the Excel to remove this field.
Published November 4, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.