Forum Discussion

Rams_2022's avatar
Rams_2022
New Contributor II
5 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 Settings -> Lead Fill Value' as 'A' in the data source as I need to append with A Infront of the account. Additionally, I have defined a transformation rule.

However, when I execute the workflow, I get the following error message: 'Validation Messages: Invalid member name. Account: 652901.'" 

Could you please suggest, is there anything that I am missing?

Data Integration
Data Sources
Workflow
  • SimonHesford's avatar
    SimonHesford
    Contributor II
    5 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 
  • MG's avatar
    MG
    Community Manager
    4 months ago

    Hi Rams_2022 

    Assuming I understand your ask correctly, I have achieved something similar using the solution SimonHesford provided as option 1. If Simon's answered helped, can you mark it as a solution?

    Thanks