Question

Querying multiple fields in a single table

S

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

imageFigure 2

Figure 2Please help me with how to get the results.

5 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @sudhakary​ 

 

I simulated your case - Steps bellow:

  • Reading the excel file
  • Split the first position attribute (ID1) - AttributeSpliter
  • Using condition of search - Tester

Print_WorkspaceI attached the Workspace template (.fmwt).

 

 

Thanks in Advance,

Danilo

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @sudhakary​ 

 

I simulated your case - Steps bellow:

  • Reading the excel file
  • Split the first position attribute (ID1) - AttributeSpliter
  • Using condition of search - Tester

Print_WorkspaceI attached the Workspace template (.fmwt).

 

 

Thanks in Advance,

Danilo

The results:

 

Results 

S

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.

M
Badge +2

@sudhakary​ can you include files instead of images and then we can experiment with the example data?

S

@markatsafe, attached is the sample CSV file

1 Attachment

Reply


Community Stats

28,723
Posts
109,514
Replies
36,561
Members
Terms & ConditionsCookie settings
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.