The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Recommended Posts

Posted

I have data that is organized by dates in columns. Tried using transformation but works only for 1 category.. How can I unpivot columns for 2 categories and keep the same date alignment See below:

Current:

 

 

 

ID

Description

1/1/2020 monthly

1/1/2020 Total

2/1/2020 monthly

2/1/2020 Total

 

 

z1

A

3.13

7154.72

2.84

7157.56

 

 

z2

B

3.31

10440.21

2.99

10443.2

 

 

z3

C

0

4628

0

4628

 

 

z4

D

3.13

5259.68

2.84

5262.52

 

 

 

Needed Transformation:

 

 

 

ID

Description

Date

monthly

Total

 

 

z1

A

1/1/2020

3.13

7154.72

 

 

z2

B

1/1/2020

3.31

10440.21

 

 

z3

C

1/1/2020

0

4628

 

 

z4

D

1/1/2020

3.13

5259.68

 

 

z1

A

2/1/2020

2.84

7157.56

 

 

z2

B

2/1/2020

2.99

10443.2

 

 

z3

C

2/1/2020

0

4628

 

 

z4

D

2/1/2020

2.84

5262.52

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...