How i can get information from Original table to Complation table?
Question
Extract table excel information to table compation
+5- Contributor
Hi, everybody. I have a table survey in excel, and now i want to complation (form exits).
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
OK. A possible way is:
Read the original table with the Excel reader.
Connect a Tester to divide the records into 2 parts, i.e. after and before of the header row. You can use row number to determine if a record is after the header row.
Connect 2nd Tester to the 1st Tester's Failed port (records before the header row) to extract the row of "Forest owner", and rename the name column attribute.
Merge the extracted owner's name attribute to every data record (from Passed port of the 1st Tester). The FeatureMerger can be used to do it.
Rename and keep required attributes, and write them into result table.