topic Data Transformation in Qlik Sense in App Development

Data Transformation in Qlik Sense

sijojoseph22 — Mon, 11 Nov 2019 07:36:31 GMT

Hi All,

We are having data in the below format

and need to convert into the below format.

Please could you advise how to achieve this.

Thanks,

Sijo

Vegar — Mon, 11 Nov 2019 07:43:43 GMT

Please explain the logic behind finding which development row that is linked to which test row.

In other words: why is Java A on the same row as Development Z and why do you have no test on the QS development rows?

Vegar — Mon, 11 Nov 2019 07:52:54 GMT

To just get the list split into four columns do something like this

Load

RowNo()

Column1 as development,

Column1 as DevResource

From data where Column1 ='Development';

Join

Load

RowNo()

Column1 as Testing,

Column1 as TestResource

From data where Column1 ='Testing';