transforming "n" dimensions into 1

[felcar2013]

hi

i have 9 columns in a table containing more than 20 and i want to transform them into only one column, so that i can use the dimension (new created column) in a bar chart.

the columns (A1,A2,..., A9) have "1" or "null" as value. How can i transform this, so that i can get a dimension called A, with dimension values as A1, A2, ...., A9 and the expression calculated in a bar chart. it is not possible to transform when uploading data

thanks

[Anonymous]

Hello,

Can you load the qvw? or You can give more information?

[felcar2013]

contactID	A1	A2	A3	A4	Column X
1	1				1
2		1	1	1	4
3				1	6
4	1		1		4
5			1		3
6	1	1	1		6
7		1	1	1	2

hi Andrea and thanks for your time

I have a table like this (from an excel file), the columns i want to transform are {A1, A2,A3,A4,A5}, column x, is another column in the table, and there are more than 20 additional columns.

I want to create something like this. A table containing the contact id and a new dimension , like A, so that i can use it as dimension in a chart

thanks

felipe

ContactID	New dimension "A"
1	A1
2	A2
2	A3
2	A4
3	A4
4	A1
4	A3
5	A3
6	A1
6	A2
6	A3
7	A2
7	A3
7	A4

[Gysbert_Wassenaar · Accepted solution]

This should work:

Table1:

Load ContactID, ColumnX, ColumnY, ColumnZ ...etc

from mysourcetable;

Table2:

Crosstable(NewA, Value)

Load ContactID, A1, A2, A3, A4, A5

from mysourcetable;

[felcar2013]

thanks, exactly what i needed