split a column in PBCS data management Export
Summary: Hi, we are trying to export data from PBCS application using Data Integration process into .csv file. we have a requirement where we would like to split our account member from 10-1001-400602 into 3 columns(10, 1001 & 400602) in our output file. I have seen the Split option using the Target expression in the data mapping option and it can only return the nth value after splitting and not all values in different columns. Any insights would be appreciated. We are doing this export to load the budget data into our peoplesoft system.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Tagged:
0