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
+51- Celebrity
- 2076 replies
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
+51- Celebrity
- 2076 replies
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:
+1- Contributor
- 2 replies
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?