I have a simple question:
I have a table that has four columns. I want to split the "Value" column by (LOT, WAFER) to get the split table attached. The column names are LOT WAFER ( i.e. LOT space and then WAFER). I want to add a delimiter between these two such that column names are LOT_WAFER or LOT | WAFER
Is there a simple way to do that? I could potentially create a new column in the parent table which is LOT_WAFER or LOT|WAFER and then split by that wafer but I was hoping if there is a way around it?
Thanks