Spaces in Extracted CSV's column header's
In every Business Intelligence Exchange (BIX) extract (.csv), column 2 and later have leading spaces in the header. This causes a failure in the Data warehousing system when using the extract.
Column 1 does not have leading spaces in the header.
Steps to Reproduce
Run the out-of-the-box PegaSample.Sample Extract. Verify column 1 and other columns. Leading spaces occur in the header from column 2 onwards.
A software use or operation error.
The data was formatted correctly. The issue was with Excel.
Perform the following local-change:
Pass -l ',' as a parameter in the pyArgs to pxExtractDataWithArgs activity.
0% found this useful