topic Load Table File w/ as specific value in Field in QlikView https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770693#M1023753 <HTML><HEAD></HEAD><BODY><P>I have two tables:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 199px; height: 80px;" width="197"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fruit</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Color</TH></TR><TR><TD style="padding: 2px;">Apple</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">Banana</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">Orange</TD><TD style="padding: 2px;">Orange</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 62px; height: 87px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 2</STRONG></TH></TR><TR><TD style="padding: 2px;">X</TD></TR><TR><TD style="padding: 2px;">Y</TD></TR><TR><TD style="padding: 2px;">Z</TD></TR></TBODY></TABLE><P></P><P>How do I load Table 2 with all rows, color = red for example?</P><P></P><P>Thanks in advance!</P><P>-Jason</P></BODY></HTML> Mon, 09 Mar 2015 22:47:07 GMT 2015-03-09T22:47:07Z Load Table File w/ as specific value in Field https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770693#M1023753 <HTML><HEAD></HEAD><BODY><P>I have two tables:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 199px; height: 80px;" width="197"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Fruit</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Color</TH></TR><TR><TD style="padding: 2px;">Apple</TD><TD style="padding: 2px;">Red</TD></TR><TR><TD style="padding: 2px;">Banana</TD><TD style="padding: 2px;">Yellow</TD></TR><TR><TD style="padding: 2px;">Orange</TD><TD style="padding: 2px;">Orange</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 62px; height: 87px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Table 2</STRONG></TH></TR><TR><TD style="padding: 2px;">X</TD></TR><TR><TD style="padding: 2px;">Y</TD></TR><TR><TD style="padding: 2px;">Z</TD></TR></TBODY></TABLE><P></P><P>How do I load Table 2 with all rows, color = red for example?</P><P></P><P>Thanks in advance!</P><P>-Jason</P></BODY></HTML> Mon, 09 Mar 2015 22:47:07 GMT https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770693#M1023753 2015-03-09T22:47:07Z Re: Load Table File w/ as specific value in Field https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770694#M1023754 <HTML><HEAD></HEAD><BODY><P>something like this:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 'Red' as Color</P><P>FROM/RESIDENT</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P></BODY></HTML> Mon, 09 Mar 2015 23:03:29 GMT https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770694#M1023754 Oleg_Troyansky 2015-03-09T23:03:29Z Re: Load Table File w/ as specific value in Field https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770695#M1023755 <HTML><HEAD></HEAD><BODY><P>Awesome, thank you Oleg!</P></BODY></HTML> Mon, 09 Mar 2015 23:48:43 GMT https://community.qlik.com/t5/QlikView/Load-Table-File-w-as-specific-value-in-Field/m-p/770695#M1023755 2015-03-09T23:48:43Z