Splitting data from excel cells

Hi All,

I could use some assistance on the problem I am facing.

The data I have looks something like this.

R-AMT517
C-ACB941, C-ACB942, C-ACB943

I want it to look like this.

R-AMT517
C-ACB941

R-AMT517
C-ACB942

R-AMT517
C-ACB943

How would I go about doing that?

Regards,

Sahil

Page 1 / 1

Hi @sahilbhouraskar, a well known method is:

AttributeSplitter: Split the comma separated values at comma into individual parts and save them in a list attribute.
ListExploder: Explode the feature on the list

Thanks @takashi, that worked like a charm.

Hi @sahilbhouraskar, a well known method is:

AttributeSplitter: Split the comma separated values at comma into individual parts and save them in a list attribute.
ListExploder: Explode the feature on the list

Hi @takashi how we can do that if the case like below?

The data I have looks something like this.

R

A, B, C

?, ?, ?

I want it to look like this.

R

A

?

R

B

?

R

C

?

How would I go about doing that?

Sign up