Update values with data table

Question

I am having issues with using this Text input solution to replace the codes from the main workflow with what the codes actually mean. I have it set so that when there is no code in the main workflow my WhatIf statement should put reason not listed in the blank. Currently after updating the codes there is nothing in the cels that should say reason not listed. Please let me know if I can provide any more information that would help to find a solution.

binu_acs · Answer

@apathetichell I agree with you, even if there is "Reason Not Listed" it will not join because of the record length

apathetichell · Answer

@binu_acs- I think in this case the join is on tasklistgroup - and there's nothing on the left side of the join for tasklistgroup - so those entities are being dropped by the join tool. That would be my hypothesis.

There are a variety of ways you could try to fix this (change the value from "Reason Not Listed" in your text input to blank or null or whatever it is on your main datastream and match or union in the left anchor the join anchor after your join and then look for nulls())... but I can't really answer this readily without seeing your join configuration and how your data looks going into your join.

binu_acs · Answer

@nicktekippe The TASK-GROUP field has the length of 8 char, which is not sufficient to accommodate the string reason not listed, change the size and try again