Dear Team,
I am looking for some idea on splitting the column by two different criteria.
Attached image for reference.
In the image you see - AA, BB, CC as 1 Category and A1...B1...C1... as another category.
@abhishekyx
Can you kindly provide the sample input and sample output in txt format?
@abhishekyx Alteryx can have only one name for a data field, or is this more for a final output?
You could try appending the names e.g A1 becomes AA-A1 if that would be any use? That would be done using the dynamic rename tool under formula using an if function