I have two sql tables.
One contains inspection records as shown:
The other contains questions for each inspection as shown:
I need to combine these and put them in access as such:
InspectionID; InspectionName; Date; InspectedBy; Old_Spill_ID; Spill_Type; etc.
Any help is much appreciated!
Best answer by mark2atsafe
It seems to me that you want to use the value of the QUESTION column in the second table as the name of a field added to the first table, with the value of the ANSWER column in the second table.
That's sort of easy enough, as long as the values of the QUESTION column are known in advance and can be manually defined in the output schema.
What you need to do is add an AttributeCreator transformer and set it up to create a new attribute called @Value(QUESTION) with the value of @Value(ANSWER)
See the attached workspace:
Then merge the two together using a FeatureMerger and write the data out to the known fields.
I'm using Excel instead of Access, and shortened a few of the attribute names to make it quicker for me, but it should work for you.
Regular FME'ers will notice the odd attribute name under the FeatureMerger, and red connections in the output. It seems to work OK and write those values, even though they aren't exposed in the workspace.
Hope this helps. You can download the workspace as a template from here.
Mark
+16Hi,
I would read one of the tables via a reader and use a joiner to add the records of the second table.
After that it a matter of attribute renaming, deleting and such that can be managed via the attribute manager.
Hope this helps.
+17You can read both tables and use the FeatureMerger (merge on InspectionID). Use the Inspection table as supplier and the Questions table as requestor. The Merged out put will be the data of the questions with the information of the Inspection added.
+17Another way of doing this is using the SQLCreator.
This transformer will take a SQL statement as the source for your FME Workspace.
The SQL would be something like:
Select * from Questions Q, Inspections I where Q.InspectionID = I.InspectionID
Hi,
I would read one of the tables via a reader and use a joiner to add the records of the second table.
After that it a matter of attribute renaming, deleting and such that can be managed via the attribute manager.
Hope this helps.
You can read both tables and use the FeatureMerger (merge on InspectionID). Use the Inspection table as supplier and the Questions table as requestor. The Merged out put will be the data of the questions with the information of the Inspection added.
Another way of doing this is using the SQLCreator.
This transformer will take a SQL statement as the source for your FME Workspace.
The SQL would be something like:
Select * from Questions Q, Inspections I where Q.InspectionID = I.InspectionID
+43It seems to me that you want to use the value of the QUESTION column in the second table as the name of a field added to the first table, with the value of the ANSWER column in the second table.
That's sort of easy enough, as long as the values of the QUESTION column are known in advance and can be manually defined in the output schema.
What you need to do is add an AttributeCreator transformer and set it up to create a new attribute called @Value(QUESTION) with the value of @Value(ANSWER)
See the attached workspace:
Then merge the two together using a FeatureMerger and write the data out to the known fields.
I'm using Excel instead of Access, and shortened a few of the attribute names to make it quicker for me, but it should work for you.
Regular FME'ers will notice the odd attribute name under the FeatureMerger, and red connections in the output. It seems to work OK and write those values, even though they aren't exposed in the workspace.
Hope this helps. You can download the workspace as a template from here.
Mark
It seems to me that you want to use the value of the QUESTION column in the second table as the name of a field added to the first table, with the value of the ANSWER column in the second table.
That's sort of easy enough, as long as the values of the QUESTION column are known in advance and can be manually defined in the output schema.
What you need to do is add an AttributeCreator transformer and set it up to create a new attribute called @Value(QUESTION) with the value of @Value(ANSWER)
See the attached workspace:
Then merge the two together using a FeatureMerger and write the data out to the known fields.
I'm using Excel instead of Access, and shortened a few of the attribute names to make it quicker for me, but it should work for you.
Regular FME'ers will notice the odd attribute name under the FeatureMerger, and red connections in the output. It seems to work OK and write those values, even though they aren't exposed in the workspace.
Hope this helps. You can download the workspace as a template from here.
Mark
+43
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
