Skip to main content
  • EN

Hello ,

I have four tables. Each table includes an attribute called result, which contains fields value  string string number. (Hello Community 30 ) ,all tables share a common attribute id 

I would like to combine the output from all four tables into a single attribute called result 

 

String                String                    String             String

String number  String number   String number.  String no. 
 

I would like the first string from each table to always appear above and the second string  and number written on the next line and All values should be combined into the same field.

Thanks on advance 

Hi ​@gogopotter90 ,

Assuming that these 4 records will be read from 4 tables - one record per table.

table id result
table 1 1 AAA BBB 100
table 2 1 CCC DDD 200
table 3 1 EEE FFF 300
table 4 1 GGG HHH 400

 

In the case above, do you want to write these two records into a single destination table? 

line id result
1 1 AAA CCC EEE GGG
2 1 BBB 100 DDD 200 FFF 300 HHH 400

 

 

 

​@takashi thanks for reply 

I need to write the output into result column ,as you wrote 

when each table have same id 

first line AAA CCC EEE GGG
Second line BBB 100 DDD 200 FFF 300 HHH 400
 

 

Thank you for confirmation.

I think the workflow shown in the screenshot could help you. See also the attached workspace example to learn more.

Hope this helps. 

Community Stats

31,788
Posts
120,755
Replies
39,405
Members

Latest FME

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.