I have a table in Excel as in Fig. how to arrayed all numbers in the second row?
Question
Excel problem
Hi,
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.
+15- Contributor
Hi,
Do you want all numbers to be in the second row or in Row2?
- In second row would be a value issue: u can use a unconditional merger.
- In Row2 would be an attribute issue: a attributecreator can do that.
Hi,
Is this an issue of renaming attributes? If so, I would use the BulkAttributeRenamer.
The BulkAttributeRenamer with this setting renames all "Row**" to "Row2".
Just be aware that "String" parameter must be a constant "Row2". It should not be an Attribute Value.
Takashi
hi,
tnx for the help, I dont have new FME, only FME 2012, and I tried it with a string replacer and does not work. have any oder idea?
How about scripting? For example, the TCLCaller with this script performs the processing similar to the BulkAttributeRenamer.
-----
proc renameRows {} {
foreach name [FME_AttributeNames] {
if {[regexp {^Row.+$} $name]} {
FME_RenameAttribute "Row2" $name
}
}
}
-----
Enter the script into "Source Code" and type "renameRows" (name of the procedure) in "Tcl Expression" parameter.
Maybe I misunderstood your question. You are trying to accumulate all rows into one row?
A possible way is:
1) Remove all empty attributes. I would use TCLCaller with this script.
-----
proc removeEmptyAttributes {} {
foreach name [FME_AttributeNames] {
if {[string compare [FME_GetAttribute $name] {}] == 0} {
FME_UnsetAttributes $name
}
}
}
-----
2) Accumulate all rows into one row using the AttributeAccumulator.
In FME 2014, the Excel reader (Read blank cells as: Missing) and the Aggregator (Mode: Attributes Only) do it.
Ah, the Excel reader in FME 2012 seems to read blank cells as missing attributes. So you don't need to remove them explicitly. Just apply the AttributeAccumulator.