Forum Discussion

Rams_2022's avatar
Rams_2022
New Contributor II
2 months ago

Workflow error

I have created a workflow profile, and the data source for the workflow is a CSV file with several columns. In this file, the second column contains account numbers. I specified the 'Text Fill Settin...
Data Integration
Data Sources
Workflow
SimonHesford's avatar
SimonHesford
Contributor
2 months ago

The lead fill value is a mask therefore entering 'A' is unlikely to have any effect unless your source value is Empty. If your Account Number is always 6 digits then you could have a leading fill value of AAAAAAA which would ensure an A was pre-pended to the account number. However if your account number is not a consistent length then it would be better to either:

  1. Add another Account source dimension to your data source and give it a static value of A
  2. Add a complex expression which would prepend A to the start of all Account codes