Hi Community,
Based on the Figure 1 table, two fields exist as mentioned and I want to find the results as mentioned in Figure 2
I tried so many transformers and had no luck.
Figure 1
Figure 2
Please help me with how to get the results.
Question
Querying multiple fields in a single table
+54- Celebrity
Hi @sudhakary
I simulated your case - Steps bellow:
- Reading the excel file
- Split the first position attribute (ID1) - AttributeSpliter
- Using condition of search - Tester
I attached the Workspace template (.fmwt).
Thanks in Advance,
Danilo
+54- Celebrity
Hi @sudhakary
I simulated your case - Steps bellow:
- Reading the excel file
- Split the first position attribute (ID1) - AttributeSpliter
- Using condition of search - Tester
I attached the Workspace template (.fmwt).
Thanks in Advance,
Danilo
The results:
+3- Contributor
Hi Danili_fme, thanks for your time and resolution.
I will narrate my requirement in detail as below.
In ID1 "111111" are having 4 duplicate values whereas the ID2 values are different for that group, I need to get the 1st record as a result, after this the ID2 "222222" need the 2nd value from ID2, and so on. Here I don't want to match the first character in ID1 and ID2.
@sudhakary can you include files instead of images and then we can experiment with the example data?
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.