Hi Folks ,
I am facing one issue , i have tried all the methods but its not working can you please help on this .
one column have data like below its there row wise (Original column)
IT Strategy& Architecture BDC India [MITX 999],Corporate & IC Solution Delivery [SVII],
Operations Solution Delivery [SVIA],
Mainframe Service [MLEM],Strategy & Architecture [MLEL]
the above 3 rows i need to split into two columns like below
1st column
IT Strategy& Architecture BDC India,Corporate & IC Solution Delivery,Operations Solution Delivery,Mainframe Service,Strategy & Architecture
2nd columns
[MITX 999],[SVII],[SVIA],[MLEM], [MLEL]
please help , working new for impala data lake . Thank You ..!