Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

How to get fields values as a one field

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

 

 

Labels (1)
1 Solution

Accepted Solutions
MatheusC
Specialist II
Specialist II

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


Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!

View solution in original post

6 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

MatheusC
Specialist II
Specialist II

@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?

MatheusC_0-1748441165352.png


- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Peony
Creator III
Creator III
Author

@MatheusC  Hi. You are correct

Peony
Creator III
Creator III
Author

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

MatheusC
Specialist II
Specialist II

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


Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
Peony
Creator III
Creator III
Author

@MatheusC that is what I need. Thank you!