Skip to main content
Solved

How to split strings then concatenate them ?


gogopotter90
Contributor
Forum|alt.badge.img+13

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 

Best answer by takashi

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. 

View original
Did this help you find an answer to your question?

3 replies

takashi
Influencer
  • April 25, 2025

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

 

 

 


gogopotter90
Contributor
Forum|alt.badge.img+13
  • Author
  • Contributor
  • April 25, 2025

@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
 

 


takashi
Influencer
  • Best Answer
  • April 25, 2025

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. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings