Data Augmentation - User Defined Column Separators

Rob Toogood

Hi There,

We have recently run into an issue with column separators in Data Augmentations - (EPM>FAW OOTB API Connection)

Some data values include Comma's in primary keys and therefore, we need the ability to use a different column separator.

When using "|" and ";", FDI Data Augmentation treats data as one column.

A good feature would be to include a drop down selector in the first page of the data augmentation to allow a user to select the column separator type - comma by default.

Krishna Prasad Kotti-Oracle

@Rob Toogood Thank you for the post.

Can you let me know if this is related to the EDMCS source?

Rob Toogood

This is data from PBCS Planning and Budgeting using the OOTB PBCS connector.