Input
Output
Very appreciated all helps
I would solve it with getting a row number for each product in the order, and then use the cross-tab with the row number as new columns.
Cool small use case!
@123love55448 This can be done by Tile too;I also use a Find and Replace tool to be a bit more dynamic for the new column names.
Hi,@123love55448
Dear, if you have few columns to group, there is a easy way:
The key point here is that the conversion of numbers and words corresponds. If you add a corresponding table, there will be no problem with more rows / columns.
Dynamic Rename Expression:
Switch(Tonumber(Left(Replace([_CurrentField_],"Column_",""), 1)),"Zero",1,"First",2,"Second",3,"Third",4,"Fourth") + Substring(Replace([_CurrentField_],"Product", "SKU"),8,20)
*******
Please mark this as the solution if it answers your question, it will help others to find solutions quicker.
@flying008 Nice one with the Make Columns tools.
Hi, @Qiu
Dear, thank you ! If the dynamic rename tool support part dynamic replace mode, the case will be more easy for many rows/columns.
