Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Field1 | Field2 | ... |
A | ... | ... |
B | ... | ... |
C | ... | ... |
How can I crate a Table2 that gets the field names from the values of Field1 of Table1, as follows:
A | B | C |
... | ... | .. |
Thank you in advance!
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.
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.
Hello Stoyan,
I tried using Generic Load, but it is creating a separate value for each value of the Field1.
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.