topic Re: How to get fields values as a one field in App Development

How to get fields values as a one field

Peony — Wed, 28 May 2025 13:00:52 GMT

Hi All.
Could anyone please give an advise how to get fields values as a single new field.

I have a table

Tab_1:
Load *Inline[
F1, F2, F3
1,2,3
4,5,6]

What I wish to have as the result is next

Tab_2:
Load
1,2,3 as String_1,
4,5,6 as String_2
Resident Tab_1

Re: How to get fields values as a one field

Oleg_Troyansky — Wed, 28 May 2025 13:29:29 GMT

Hi Peony,

You can calculate that using the Concat() function.

Cheers,

Oleg Troyansky

Re: How to get fields values as a one field

MatheusC — Wed, 28 May 2025 14:06:38 GMT

@Peony

I was in doubt when you say a single new field.

To me it looks something like this. Would this result be a single field, for example FieldName, distributing the values?

- Matheus

Re: How to get fields values as a one field

Peony — Fri, 30 May 2025 14:04:50 GMT

@MatheusC Hi. You are correct

Re: How to get fields values as a one field

Peony — Fri, 30 May 2025 14:04:21 GMT

@Oleg_Troyansky Hi. Contcat() gives not the exact result I'm trying to achieve. @MatheusC describe what I am looking for better

Re: How to get fields values as a one field

MatheusC — Fri, 30 May 2025 15:02:03 GMT

Ok so if this is the case, you can try to explore this solution, a generic table creating the values for the field:

Like this example below:

Generic:
LOAD
'String_' & RowNo() AS FieldName, // Criamos nomes dinâmicos para cada linha
F1 & ',' & F2 & ',' & F3 AS Value
Resident Tab_1;

- Matheus

Re: How to get fields values as a one field

Peony — Wed, 04 Jun 2025 06:54:36 GMT

@MatheusC that is what I need. Thank you!