Forum Discussion
HELP TO GRAPH multiple data
Step by step...
Select the column and, under the Home tab, click on Split column -> by delimiter
Type in the delimeter in the box, and in advanced options chooe split into rows.
Finally select the column and under the Transform tab, select Format and Trim and then Clean.
HELLO. ty for your time...
i have to do the analisys of that data and i have a problem...
One of those cells have multiple data in one cell for example
ID DATA
X A / B / C / D
Y C / D
I need know how many have each ID in ESPECIFIC data and get that in a table:
A B C D TOTAL
X 1 1 1 1 4
Y 1 1 2
6
I tried to do that with split column but the table just give me the first data found in the first column
A B C D TOTAL
X 1 1
Y 1 1
2
I managed to do the exercise by making a table by column, but I need the data in a single table like this:
A B C D TOTAL
X 1 1 1 1 4
Y 1 1 2
6
Hi ipso ,
In query editor, let's start with base data (sample):
Then split column as below:
that's it.
Then close and apply the changes of query editor.
Now u can use this table data in matrix visual to get exact same format data you intend to make:
I did this with a visual, and the table created is long format. I think this is fine, if you really want to take advantage of dimensional design, by later relating a dim table with DATA fields.
Pls let me know if your desired outpt must be in the table only.
Hope it helps.