需要转置以下数据以生成每个记录 [英] Need to transpose the following data to generate a record each

问题描述

名字child1 sex1 child2 sex2 child3 sex3

-------------------------------- -------------------------------------------------- ----

Jan Rown Peter Rown男性火腿男性Amy Rown女性

Pal Sax John Sax男性Allen Sax男性



转置上述数据以生成以下记录



name child_name sex

--------- -----------------------

Jan Rown Peter Rown男性

Jan Rown Ham Rown男

Jan Rown Amy Rown女性

Pal Sax John Sax男士

Pal Sax Allen Sax男士



我尝试过的事情：



检查参考文献的早期编码，我不能得到帮助。



检查网但是没有确切的例子

name child1 sex1 child2 sex2 child3 sex3
--------------------------------------------------------------------------------------
Jan Rown Peter Rown Male Ham Rown Male Amy Rown Female
Pal Sax John Sax Male Allen Sax Male

Transpose the above data to generate the following records

name child_name sex
--------------------------------
Jan Rown Peter Rown Male
Jan Rown Ham Rown Male
Jan Rown Amy Rown Female
Pal Sax John Sax Male
Pal Sax Allen Sax Male

What I have tried:

Checked earlier coding from references and I coudn't get help.

Checked the net but coudln't exact example

推荐答案

看看UNPIVOT：使用PIVOT和UNPIVOT [ ^ ]

Look at UNPIVOT: Using PIVOT and UNPIVOT[^]

这篇关于需要转置以下数据以生成每个记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！