Hi,
I'm having an issue with a delimited file source.
The file is actually a column from a big query wich contains a CLOB, that clob has the next format : parameter1:value1;parameter2:value2;parameter[n]:value[n]; ........
What i want is to convert the rows to columns and values in this way :
| parameter1 | parameter2 | parameter[n] |
| -------- -------| ---------------- | ----------------- |
| value1 | value2 | value[n] |
Can you please help me out with an ideea regarding this ?
I tried a few solutions but i end up with 2 columns, parameter and value and multiple rows with data it self. For this i used as *Column delimiter *** :** and as *End of line delimiter* **;**
| Column 1 | Column 2 |
| ------------- | -------------- |
| parameter1| value1 |
Using pivot functionality would be an ideea but the data inside the clob is not FIXED, it's dynamic and i have to find a solution to make it work on large scale.
Any ideeas, hints are appreciated.
Thank you !
Have a good day!
