After getting the Filename from file, locate column that matches or use Filename as a Variable for the ColumnName to execute the join operation.
Using something like “column(variable(“Filename”))”"
Use the File to get the matching rows to use in a join
Matching Column of Filename is set to “True” with a Join based on pro_Part_Code for the column that represents the Filename and all other rows should remain False of course.
That’s a great workflow that @TardisPilot put together. If you can take that as a starting point, maybe you could come up with your own workflow using a small subset of your data? Then we could help you refine and troubleshoot that for your particular use case.
This will find all of the rows that have “?” and update the Column that is specified however,
I am looping through the files and I need to update the column that is a variable within the loop. The variable name is $File name$. But this is just the column name that I want to update with True. I was thinking of something like column($File Name$) > 0 = “TRUE” but that did not work and it also still wants me to select a column to apply this to which in my case the column will always change as it goes through the loop.
Maybe the Column Expression Node would be a better approach. I don’t know if that is a different application or not for updating a Table Column? Any Thoughts. Thx
There is a bit of a trick to identifying missing values in the Rule Engine node, but it’s possible. Try
MISSING $$ROWID$$ => "yes"
You’re right that the Column Expressions node will probably offer a more dynamic solution, though. It can be challenging to put together complex conditionals using just the Rule Engine, since you may need a series of Rule Engines nodes to get it done.
I would encourage you to upload your workflow with a dummy dataset, if you can - you’re much more likely to get people tinkering with it that way, as opposed to just screenshots.
I will attempt to go to the Column Expressions node with some Flow Variables. I appreciate the insight, very helpful.
I will update a sample or solution in a bit.
Here is my attempt. Forgive my scatter brain on the idea, I am just trying soo many different things which make me feel that it is easier than what I am attempting.