This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is there a reason the Dynamic Rename tool might ignore a right input when the Rename Model is set to "take field descriptions from right input rows"? Looking at the xml file it appears the field description simply matches field name for all the left inputs instead of the omitting the field description when it doesn't find a matching field name in the right input.
Using Dynamic Rename with 'Take Field Descriptions from Right Input Rows' there are two options:
First is to use positional rename.
If this is the case, each column in the left input data is going to be matched by position to a row in the right input. First left input column to first right input row and so on. If the number of columns on the left don't match the number of rows on the right Dynamic Rename will do the best it can matching first left input column to first right input row and so on.
You could also choose a field that has column names and a field that contains descriptions. This will set the description found in [Description Field] column to column names that match the strings in [Field Name] right input column.
As to your specific question, Dynamic Rename might ignore a right input row when there are more rows in the right input than there are columns in the left input.
Thanks Michael. I modified your workflow to capture the precise problem, which in this case doesn't actually manifest itself -- the modified workflow works as expected. As you can see I'm adding in a Dynamic Select and including the [Description]=[Name] expression in order to filter the left input using the rows from the right input. As you can see this solution works, however, I have a workflow where it appears to be ignoring the right input list but am unable to diagnose why.
Yes, that's correct. The workflow I attached to my previous post works as expected, however, when I use this same type of workflow as part of a larger one it doesn't seem to recognize the right input list. The only clue is that the left Dynamic Rename input is originating from an upstream Dynamic Select rather than a data source. Could this be the problem?
Sorry, I know you asked for the workflow, but I would need to create a generic version of it that removes the source data.