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
ASHISH, TAHNKS a lot for your time
it´s not so simple becose i have more than 1000 dates.
as you can see here i divided them:
when sorted them into the array I need, it brings me only the ones from the first column,
these would be the values placed in the array
I could get a table for each separation but you need all the data in the same table
so I made this table separating each of the variables to take it and cross it with the data
Here it generates the first error
As you can see, an error was generated crossing the information, but in addition to that when I try to make the table, the "pqrs classifications" do not appear in the table.
I appreciate your help BLESSINGS
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.
