For the second case:
I have URLs from a second source, reconciled-URL. I want to merge it with the URL-derived-from-name, and prefer the reconciled-URL. To say this in a scripting language, I imagine I’d say something like, if there is a reconciled-URL, go with that, else take the derived-from-name, else blank.
Then there are lots of options but assuming both these URLs are already in your project (I'm not clear?) you could do:
- Add new column based on your 'reconciled-URL' column, just to copy that into a new column
- Use Facet by blank on this new column to find the rows where there is no value
- Make sure only the rows with the blank cells are showing in the data grid and then do a Transformation on this column with GREL like
cells["url-derived-from-name-column-name"].value
The last step will put in the value from your derived-from-name url column into the blank cells of your new column. And any remaining cells will still be blank
You can definitely achieve the same outcome with a GREL expression using conditional statements like if and with Jython as well - but I'd say the use of facets here is probably simpler.
I'm very happy to share some illustrations or examples or answer questions if you have them