Now I wish to append this date as a new field on all records of another table coming from Oracle. Each record from Oracle should have the same new field called Last_Export and the same date coming from the Excel spreadsheet.
FeatureMerger does not work as I don't have a common attribute between the two tables.
+21
I am trying to get the location curve property for walls using FME and Revit Reader. To be clear, this is not the geometry of the wall, but the line Revit uses to create the wall. From what I can tell, the property is not in the actual file itself, but the result of a Revit API method:
wall.Location as LocationCurve
I use Python scripts in Dynamo, but this is unknown territory for me. Is it possible to install Revit API modules and do something like this?
import fme
import fmeobjects
from Autodesk.Revit.DB import *
def locLine(feature):
line = feature.Location.Curve
if isinstance(line, fmeobjects.FMELine):
cLine = line.getAsLine()Any insight is appreciated. For now, I will get the lines in Dynamo, export to Excel, and then merge in FME. Not very elegant!
Thanks,
@lorenrouth
+13
You could create a dummy value on both inputs (merge = 1) to use in the feature merger.
Hope this helps
What I really want is to use the single value retrieved from the Excel spreadsheet as the Right Value in my Tester. I hoped that if I could attach the value to every incoming record, that would help.
I have 18000 records coming in from Oracle. I have the one record coming in from Excel. I put the VariableSetter after the Excel and then the Variable Retriever. This single value plus the 18000 records go into my Tester. The Left Value is from Oracle and the right value, which I need to compare against all 18000 records is from the VariableRetriever. The variable seems to be blank at this stage as the passes records are not correct.
Hope this makes sense.
+21
+21
+13
That way all the oracle features will receive the xls value.
After that you can test the oracle attributes to the xls merge att value.
Itay
+17
I think Itay's way (FeatureMerger) is simple and good one. There is another way with SQLExecutor transformer. 1) Input the feature (only one) having Last_Update to SQLExecutor as INITIATOR. 2) Setting parameters of the SQLExecutor are: SQL Statement: an appropriate 'select' statement to get all records to which you need to append Last_Update Combine Attribute: 'Keep Initiator Attributes if Conflict' Then, all output features (records) will have the same Last_Update.
Takashi
+13
Itay
+25
Basically this was common enough for me that I created this custom transformer and shared it online. Like Itay suggests, it just uses a dummy value to merge everything from one feature onto a set of others.
Hope this helps
Mark
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
