A kind of transposition - is it possible

Hi,
Let's say I have data in a table with columnames of key, col1, col2, col3. Note name of first column is key in this example- could be anything. Can I have this data converted into a table having these columns - key, colname, colvalue.

Example
Original data:
Key, col1, col2, col3
1,a,b,c
2,p,q,r

Should become
Key, colname,colvalue
1,col1,a
1,col2,b
1,col3,c
2,col1,p
2,col2,q
3,col3,r

Is this kind of a Transposition possible?
R

Is this data that is already in Elasticsearch? If so look at https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.