topic Re: How create table with all possible combination of fields? in QlikView https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404117#M613107 <HTML><HEAD></HEAD><BODY><P>Yes, because in another table we can have different combination of field</P><P>USA</P><P>USA OR New York</P><P>New York AND USD</P></BODY></HTML> Thu, 16 Nov 2017 10:53:21 GMT vchuprina 2017-11-16T10:53:21Z How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404115#M613105 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How can I dynamically generate field with all possible combination of fields.</P><P>How can I do this in qlikview</P><P>For example:</P><P>In table below I have three field</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>City</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Currency</STRONG></TH></TR><TR><TD style="padding: 2px;">USA</TD><TD style="padding: 2px;">New York</TD><TD style="padding: 2px;">USD</TD></TR><TR><TD style="padding: 2px;">Italy</TD><TD style="padding: 2px;">Rome</TD><TD style="padding: 2px;">Euro</TD></TR><TR><TD style="padding: 2px;">England</TD><TD style="padding: 2px;">London</TD><TD style="padding: 2px;">GBP</TD></TR></TBODY></TABLE><P></P><P></P><P>Combination for one row:</P><P>USA</P><P>New York</P><P>USD</P><P>USA &amp; New York</P><P>New York &amp; USA</P><P>USA &amp; USD</P><P>USD &amp; USA</P><P>New York &amp; USD</P><P>USD &amp; New York</P><P>USA &amp; New York &amp; USD</P><P>New York &amp; USD &amp; USA</P><P>USD &amp; New York &amp; USA</P><P>...</P></BODY></HTML> Thu, 16 Nov 2017 10:40:16 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404115#M613105 vchuprina 2017-11-16T10:40:16Z Re: How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404116#M613106 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>All this combination do you want to be in one Column?</P></BODY></HTML> Thu, 16 Nov 2017 10:48:31 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404116#M613106 mdmukramali 2017-11-16T10:48:31Z Re: How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404117#M613107 <HTML><HEAD></HEAD><BODY><P>Yes, because in another table we can have different combination of field</P><P>USA</P><P>USA OR New York</P><P>New York AND USD</P></BODY></HTML> Thu, 16 Nov 2017 10:53:21 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404117#M613107 vchuprina 2017-11-16T10:53:21Z Re: How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404118#M613108 <HTML><HEAD></HEAD><BODY><P>Sounds like a complex for loop.</P><P></P><P>For each row in table ...</P><P>concatenate&nbsp; with each column...</P></BODY></HTML> Thu, 16 Nov 2017 11:22:20 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404118#M613108 jpenuliar 2017-11-16T11:22:20Z Re: How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404119#M613109 <HTML><HEAD></HEAD><BODY><P>hi Vitalii,</P><P>this could be useful to you.</P><P>let me know <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Nov 2017 13:17:24 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404119#M613109 Anonymous 2017-11-16T13:17:24Z Re: How create table with all possible combination of fields? https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404120#M613110 <HTML><HEAD></HEAD><BODY><P>Maybe not. There is a way to do this in a single load but with a lot of expressions. Imagine that the source table containing columns Country, City and Currency is called er... <SPAN style="font-family: 'courier new', courier;">SourceTable</SPAN> !</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Combinations:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD RecNo() AS SourceRow,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; IterNo() AS Iteration,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp; Pick(IterNo(),</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country &amp; ' &amp; ' &amp; City,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City &amp; ' &amp; ' &amp; Country,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country &amp; ' &amp; ' &amp; Currency,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&amp; ' &amp; ' &amp; Country,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City &amp; ' &amp; ' &amp; Currency,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&amp; ' &amp; ' &amp; City,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country &amp; ' &amp; ' &amp; City &amp; ' &amp; ' &amp; Currency,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Country &amp; ' &amp; ' &amp; Currency&amp; ' &amp; ' &amp; City,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City &amp; ' &amp; ' &amp; Country &amp; ' &amp; ' &amp; Currency,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; City &amp; ' &amp; ' &amp; Currency&amp; ' &amp; ' &amp; Country,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&amp; ' &amp; ' &amp; Country &amp; ' &amp; ' &amp; City,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&amp; ' &amp; ' &amp; City &amp; ' &amp; ' &amp; Country</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) AS CountryCityCurrencyCombination</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">RESIDENT SourceTable</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">WHILE IterNo() &lt;= 15;</SPAN></P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Thu, 16 Nov 2017 13:37:21 GMT https://community.qlik.com/t5/QlikView/How-create-table-with-all-possible-combination-of-fields/m-p/1404120#M613110 Peter_Cammaert 2017-11-16T13:37:21Z