Crosstable?

[#1]

Hi all,

i have a table like this:

ID	Facebook	LinkedIn
123	true	false
456	false	false

And i would like to transform it into something like this:

ID	Social	Value
123	Facebook	true
123	LinkedIn	false
456	Facebook	false
456	LinkedIn	false

How can this be done ?

Thanks a lot!

K

[MayilVahanan · Accepted solution]

HI

Try like this

CrossTable(Social,Value)

LOAD * Inline

[

ID,Facebook,LinkedIn

123,true,false

456,false,false

];