Dynamic input issue - problem with "in" clause?

alex_reevoo

Hello all,

I'm running a dynamic input tool to replace id's for different "branches"

A clause might look something like this: in(708,2594,108) 

A sample input file is attached, as is my workflow.

For some reason, the dynamic input is having trouble populating the data for all rows. It gives field conversion errors which might be the cause but I can't figure out why it isn't working consistently.

Does anyone have any thoughts?

Thanks,

Alex

dynamic_example.yxmd

sample.csv

RodL

Using the IN clause in the dynamic input, it expects the values for the IN clause to be in "vertical" format (i.e., one per record) and then it combines them and inserts the appropriate commas.

Since you have your data already configured with the IN values in a single record with commas, you should change the Modify SQL Query expression from "Update a WHERE clause" to "Replace a Specific String". This way it will just replace your "123,123,123..." with the string value in your target_branch_code field, and it will run as is.