Hi new at this...
I am trying to separate some data from a CSV separated by a comma and then merge it back into one feature, I can't work out how to merge the 4 results I get from each entry.
Best answer by f.kemminje
View originalHi new at this...
I am trying to separate some data from a CSV separated by a comma and then merge it back into one feature, I can't work out how to merge the 4 results I get from each entry.
Best answer by f.kemminje
View originalHello, could you kindly elaborate on your query? I fail to grasp the issue.
when I split up a an attribute that was originally in one attribute sepperated by "_", by using list exploder and attribute splitter, I get back 4 features for each attribute.
Original data had two features with three attributes:
1. A_B_C_D BLUE
2. A_B_C_D RED
My failed results became eight features with three attributes:
1 A BLUE
1 B BLUE
1 C. BLUE
1 D. BLUE
2 A RED
2 B. RED
3 C RED
4 D RED
What I wanted to do was return each letter in a separate attribute keeping it as one feature with all the original attributes so 2 features with 6 attributes.
1. A. B. C. D. BLUE
2. A. B. C. D. RED
I hope this make more sense I'm not very good at this whole thing got stuck here for most of the day!!
when I split up a an attribute that was originally in one attribute sepperated by "_", by using list exploder and attribute splitter, I get back 4 features for each attribute.
Original data had two features with three attributes:
1. A_B_C_D BLUE
2. A_B_C_D RED
My failed results became eight features with three attributes:
1 A BLUE
1 B BLUE
1 C. BLUE
1 D. BLUE
2 A RED
2 B. RED
3 C RED
4 D RED
What I wanted to do was return each letter in a separate attribute keeping it as one feature with all the original attributes so 2 features with 6 attributes.
1. A. B. C. D. BLUE
2. A. B. C. D. RED
I hope this make more sense I'm not very good at this whole thing got stuck here for most of the day!!
Here is the w bench file
when I split up a an attribute that was originally in one attribute sepperated by "_", by using list exploder and attribute splitter, I get back 4 features for each attribute.
Original data had two features with three attributes:
1. A_B_C_D BLUE
2. A_B_C_D RED
My failed results became eight features with three attributes:
1 A BLUE
1 B BLUE
1 C. BLUE
1 D. BLUE
2 A RED
2 B. RED
3 C RED
4 D RED
What I wanted to do was return each letter in a separate attribute keeping it as one feature with all the original attributes so 2 features with 6 attributes.
1. A. B. C. D. BLUE
2. A. B. C. D. RED
I hope this make more sense I'm not very good at this whole thing got stuck here for most of the day!!
Thank You so much that worked.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.