rename the nth row , without disturbing the first few rows.

[Prp197]

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.

[Yoshiro_Fujimori]

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.

[RobertOdera]

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!