Renaming

[Mhnd]

I have an issue, I have this Excel file wich has three sheets (Before) for the data before I put it in Alteryx and the second sheet (After) where I stuck in my Workflow so i extract it to explain the issue, the last sheet (Solution) where I want adjust my workflow to reach.
Notice that the sheet (Before) is not input by itself I used macro to deal with other issues so I ending up to the sheet (After).
Thanks.

[Yoshiro_Fujimori]

Hi @Mhnd ,

Here is one way of doing this. I hope this helps.

Workflow

Output

You can change the column order at Select tool.

As I did not see the data for Sheet Name on your output, I did not work on it. But you can get the information by changing Input Data tool.

[Mhnd]

sorry it was my bad, I want resolve the issue on the sheet (After), notice that the headers contains column names then F2 comes after them.

[Yoshiro_Fujimori]

Hi @Mhnd 

If that is a matter of column order, you should be able to change it with Select tool.

Is there any other problem?

[Mhnd]

this report is weekly so I want each type pick it's class dynamically  even if the order change every week.

Thanks