join tool not updating

[avuong6]

hello 

i have this process:

i recently updated the sql to pull an extra field from the database as show in orange

when i look in the join tool, the new field is not coming thru:

so how to get the join tool to recognize the new column 'hiekey'

[Felipe_Ribeir0]

Hi @avuong6 

Did you run the workflow (not the app) at least 1 time with this new config to generate the metadata?

Try doing this.

[avuong6]

yes, pressed this button:

[avuong6]

not in meta data window:

[avuong6]

yes, pressed run button.

data is not in data stream out tool:

[RobertOdera]

Hi, @avuong6 

Consider the following:

1. In the Join Tool configuration: Options --> Save/Load --> Load Field Names

2. In the Union Tool configuration: either click into the tool (and that should be enough) OR Configuration --> Output All Fields

3. Inspect whether that new field is in both streams and therefore outputting through the J node versus L or R (and if so, add a connect to the Union)

Cheers!

[avuong6]

1) did that and it only opens up a dialog box:

2) already set as is

3) new field is not there

[StellaBon]

You could

1) If you are writing back to the database, create the new field in the database first, just as a field name- so it exists.

2) Alternately, use a Text Input Tool to create and add the new field name to the data stream before the join.

3) Try both 1 & 2  concurrently

S

[avuong6 · Accepted solution]

so i figured out what the issue is:

in my sql, i used variable name where i want to update the code:

but this produces an error as it cant find the table. this didnt matter because at run time it updates the variable name to the correct table and runs. but when not running, this error causes the other tools not to work. 

so i updated the code to use the correct table name instead of a variable. then i updated the update tool to replace the table name and it worked. any sql code change flowed thru to the join tool.