Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Example: Column 1 is my description and Column 2 is my grouping. How can I set a certain condition where it can differentiate what I'm grouping by from Column 1?
Column 1 Column 2
1k k
1k k
1k k
2b b
2b b
2b b
2b,1k bk
2b,1k bk
2b,1k bk
Any help would be appreciated.
Maybe like
LOAD
Column1,
PurgeChar(Column1,'0123456789,') as Column2
FROM ...;