I have a table in Excel as in Fig. how to arrayed all numbers in the second row?
I have a table in Excel as in Fig. how to arrayed all numbers in the second row?
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.
If u mean to collapse all values to Row2:
try this
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
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?
-----
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.
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.