Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Peony,
You can calculate that using the Concat() function.
Cheers,
Oleg Troyansky
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
@MatheusC Hi. You are correct
@Oleg_Troyansky Hi. Contcat() gives not the exact result I'm trying to achieve. @MatheusC describe what I am looking for better
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
@MatheusC that is what I need. Thank you!