Troubleshoot | values
Last updated
Last updated
In 5.0.1 a new option is added to choose between a | separated list or the first found value.
If you have issues with | (pipe) separated values when using Dynamic Values in Data Correct, please follow this video to solve it. This issue only occurs if you are connecting to a worksheet with multiple marks, WriteBackExtreme will add all values it can find with a | separated. This is handy because you can use the 'Create a separate record per mark' option to generate multiple rows for every selected mark.
The solution is using a helper worksheet with only the relevant values for the dynamic population.