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

Announcements
Join us in Bucharest on Sept 18th 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!