Reformatting the data

[Tharashasank]

Hi All,

I have a data set which is mentioned below  here i cannot do the split using a delimiter .i need it to be dynamic because there will be a case where we will have more than 20 separated (;) value.

Product id	error messages
1
2	a;b;c;d;e
3	b;a;c
4
5	x;y;z
6	d;e;f

I Want the o/p like the below one:

Product id	error message
1
2	a
2	b
2	c
2	d
2	e
3	b
3	a
3	c
4
5	x
5	y
5	z
6	d
6	e
6	f

[JordanB]

Hi @Tharashasank

You can use a text to columns tool for this and split to rows based on ; delimiter 

Best,

Jordan Barker

Solutions Consultant

[Tharashasank]

Hi Jordan,

I want to split them dynamically. In your mentioned approach we are mentioning the value of delimiters. In my scenario there will be a case where they may be more no.of delimiters.

Thanks,

Tharashasank

[JordanB · Accepted solution]

Hi @Tharashasank

You can add multiple delimiters into the delimiters box. Just add the new delimiter next to the ;

I just used ; as that was the only value in your example. 

Best,

Jordan Barker