topic Changing row column to value. in App Development

Changing row column to value.

Dilie — Thu, 10 Sep 2020 10:29:47 GMT

I load in my data from JIRA with the REST connector. Now in this way the values of this table are put as column names.

My data is now like this:

custom_field1 | custom_field2 | custom_field3

Rank Support Help

I want it to change to this:

id | value

custom_field1 | Rank

custom_field2 | Support

custom_field3 | Help

Could anyone help me with this or put me in the right direction with documentation? English is not my first language so I don't know how to specify searching for this.

Re: Changing row column to value.

Vegar — Thu, 10 Sep 2020 10:39:48 GMT

You can solve this by using Crosstable

Crosstable(Entity, Value, 1)

Load '' as dummy, custom_field1, custom_field2, custom_field3

From Source ;

Drop field dummy;

I'm using dummy field as the funtion needs at least one qualifying (not pivot) field.

Re: Changing row column to value.

Dilie — Thu, 10 Sep 2020 11:31:38 GMT

Thanks it worked I have a lot of those columns, is there any way to loop through these columns and do the same? I need to learn how this crosstable works but after testing it works.

Thanks for your help!