cancel
Showing results for 
Search instead for 
Did you mean: 

Convering a wide table to a long table (Reshape Tidyr, Reverse Pivot)

Former Member
0 Kudos

I have a data set that has variables spread across row and column names:

    

DimensionAppleTomato
Width12
Height24

I want convert this so that variables do not appear as column titles:

              

ProduceDimensionValue
Apple

Width

1
AppleHeight2
TomatoWidth2
TomatoHeight4

In R, I would do this with reshape, or tidyr. It's like doing reverse pivot in excel.

In tidy data language, I want to covert a wide table to a long one.

How should I do this in Lumira?

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

I don't think you can do this now; this is an Idea in SAP Idea Place to vote for this feature - see https://ideas.sap.com/ct/ct_a_view_idea.bix?c=6013C007-A70B-4283-93CE-2531683D816D&idea_id=4217B756-...

Answers (0)