Forum Discussion

Durbs's avatar
Durbs
New Member
8 years ago
Solved

How to create multiple columns from a single source column

Hi all,    First post, had a search but couldn't find my query answered.   Using API to our own cloud-hosted software, I've successfully downloaded the relevant tables to start populating the gra...
  • ImkeF's avatar
    ImkeF
    8 years ago

    You have to pivot column "Data_Field" with column "Data_Value" for values. 

    In the advanced options choose "Don't aggregate".

ImkeF's avatar
ImkeF
Community Champion
8 years ago

You have to pivot column "Data_Field" with column "Data_Value" for values. 

In the advanced options choose "Don't aggregate".

  • Durbs's avatar
    Durbs
    New Member
    8 years ago

    That's great thanks :)

     

    I had to remove some preceeding columns before converting to pivot or I ended up with various NULL fields in double lines, but that's perfect.