Renaming

Question

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.

Issue.xlsx

Mhnd · Answer

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

Thanks

Yoshiro_Fujimori · Answer

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 · Answer

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.

Screenshot 2023-06-18 173148.png