Skip to main content
Question

remove duplicate id at first attribute and change any value in second attribute for new values that contains the same value of id

  • March 13, 2020
  • 2 replies
  • 17 views
gogopotter90
Contributor
Forum|alt.badge.img+14

 

input

 

required output

 

 

 

i have duplicate ,same many id in first column

for each duplicate has different values in attribuute world

as input excel

for id 400 has 1,2,7

so i want to extract one id from the duplicated one id called 400 for the three duplicated id and in front of this id 1,2,7 change all values in attribute world that contains 1,2,7 to new value for any id not included in world attribute

then chack again if we have another duplicate value in id attribute ,

same method ,extract one id as 267 and it contains 3,11 in attribute world so change any value in attribute world to new value for any id

so i want to check at first column if i have duplicate of id in first column so i want to extract only one id from duplicate and it contains 3,11 so change any value in world attribute than contains 3,11 for any value to new value not in cluded in world attribute

 

i mentioned in color background ,what i need to do exactly .

iam not sure how to do that,i hope someone suggests me good idea.

Thanks alot

 

 

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • March 13, 2020

Hi @gogopotter90, if I understand your requirement correctly, this workspace example might help you.

example.fmwt (FME 2018.1)

But I don't know why the "3" in the line of ID = 223 wasn't changed in your example...

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
gogopotter90
Contributor
Forum|alt.badge.img+14
  • gogopotter90Contributor
  • Author
  • Contributor
  • 239 replies
  • March 13, 2020

Hi @gogopotter90, if I understand your requirement correctly, this workspace example might help you.

example.fmwt (FME 2018.1)

But I don't know why the "3" in the line of ID = 223 wasn't changed in your example...

u r perfect ,tahnks alot .sry i forgot to change number 3 to new value but what u did ,what i need exactly.Thanks alot for ur help

Community Stats

32,076
Posts
121,798
Replies
39,707
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.