Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
limu
Partner - Contributor II
Partner - Contributor II

Create a table with fields from another table's field values

Hello,

How can you create a table where the fields are crated from the values that are found in a field from another table?

Example:

Table1:

Field1Field2...
A......
B......
C......

 

How can I crate a Table2 that gets the field names from the values of Field1 of Table1, as follows:

ABC
........

 

Thank you in advance!

Labels (2)
1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Limu,

 

Check this article, it explains how you can achieve it:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

 

Regards,

S.T.

View solution in original post

3 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Limu,

 

Please check this thread:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Problem-with-crosstable/m-p/1652295#M48678

You need to use Generic Load.

 

Kind regards,
S.T.

limu
Partner - Contributor II
Partner - Contributor II
Author

Hello Stoyan,

I tried using Generic Load, but it is creating a separate value for each value of the Field1.

Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Limu,

 

Check this article, it explains how you can achieve it:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

 

Regards,

S.T.