Forum Discussion
Splitting rows to separate values
Hi! I have "Change Impacts" that have have 2 columns with infotmation. One is "E2E" and the other is "Type". Those columns can have more than one info, splited with a "," as yoy can see in the "Type" column.
I need to create graphs counting each "Chane Impact ID" by "E2E" and "Type", incuding the values that are splitted by a ",". Any idea on how I could do it?
Anonymous
what about split to rows?
then you can count each value separately.
Hi,
In the Query Editor, split the contents of the Type column by rows using the comma delimiter.
2 Replies
Anonymous
what about split to rows?
then you can count each value separately.
Hi,
In the Query Editor, split the contents of the Type column by rows using the comma delimiter.