can any one please help me to rename the nth row. without changing the first few rows.I want to rename in 11 row.screenshot below.
Though there are multiple ways to update a specific row,
I would use RecordID tool, and then use the ID to find the row to rename in Formula tool.
Each field needs to be renamed.For example, for [F1] field,
IF [RecordID] = 11
THEN "New F1"
ELSE [F1]
ENDIF
Depending on the length of the original field, you may need to expand the length as necessary.
I hope this may help. Good luck.
Hi @Prp197
It is best if you provide a text sample that we can us. However, consider:
1. Record ID1 tool to ID each row
2. Use a Filter Tool to select the target row (True)
3. Use the Transpose Tool
4. Add another Record ID2 Tool
5. Add a Formula Tool to rename each Name and/or Value for each Record ID2
6. Crosstab to get back into the row with new changes
7. Use Union Tool to append the new row to the False of step 2 Filter
8. Sort by record ID1
Cheers!