Hi all,
I just want to understand if there a way to unpivot table (data) in Gainsight?
For example, if you look at this image; ID1 has values for ABC and XYZ and ID2 has only for DTE. Left hand side the data we have and on the right hand side is what we need to have
Thanks,
I’m not sure if you can do anything else besides a multiple Union...
Dataset 1, Transform. Select the name and first column. Rename it from ABC to version
Do a case evaluation, string output, call it Unpivot . If field ABC is not null, ABC, else null
Dataset 2 transform, repeat: select the name and second column. Rename it from XYZ to version
Add a a case evaluation, string output, call it Unpivot . If field XYZ is not null, YXZ, else null
Do this until all your columns are “unpivoted”. Union dataset 1 with 2, then that with 3. Having all your datasets with the same column names makes this part easier.
Do a last transform to filter version != null
If you already have a profile on Gainsight Community, there's no need to create another one. If your email address has changed or you can't remember your login, email community@gainsight.com. Otherwise, continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
