topic Different field name that are the same in QlikView https://community.qlik.com/t5/QlikView/Different-field-name-that-are-the-same/m-p/293897#M706241 <HTML><HEAD></HEAD><BODY><P>Well, you probably have somewhere a list that relates your head coporations to their subcompanies. If you don't, I think there is no way around creating one.</P><P></P><P>You then load this table to your data model, this will link your activities table to financials table.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 20 Jan 2012 14:12:31 GMT swuehl 2012-01-20T14:12:31Z Different field name that are the same https://community.qlik.com/t5/QlikView/Different-field-name-that-are-the-same/m-p/293896#M706240 <HTML><HEAD></HEAD><BODY><P>There are two .xls files one containing data about activities done with clients, and the other contains information about financials.&nbsp; The accountant charges the head corporation.&nbsp; The other details are done with subcompanies so they all have different names.&nbsp; I need a way to take company x and y and be the same company z when it comes to billing.&nbsp; I'm totally lost in this regard.&nbsp; </P><P></P><P>Pls don't tell me to standardize my data.&nbsp; In about six months to a year there is plan to go with a DB that I will eventually have to build.</P></BODY></HTML> Fri, 20 Jan 2012 13:57:04 GMT https://community.qlik.com/t5/QlikView/Different-field-name-that-are-the-same/m-p/293896#M706240 2012-01-20T13:57:04Z Different field name that are the same https://community.qlik.com/t5/QlikView/Different-field-name-that-are-the-same/m-p/293897#M706241 <HTML><HEAD></HEAD><BODY><P>Well, you probably have somewhere a list that relates your head coporations to their subcompanies. If you don't, I think there is no way around creating one.</P><P></P><P>You then load this table to your data model, this will link your activities table to financials table.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 20 Jan 2012 14:12:31 GMT https://community.qlik.com/t5/QlikView/Different-field-name-that-are-the-same/m-p/293897#M706241 swuehl 2012-01-20T14:12:31Z