topic Profiling of Data Market Data not working in QlikView https://community.qlik.com/t5/QlikView/Profiling-of-Data-Market-Data-not-working/m-p/829504#M469861 <HTML><HEAD></HEAD><BODY><H2>Description</H2><P>When loading data from data market into an existing data model, the data profiling does not seem to work. Regardless of whether i load the data from data market first or second. see steps below. Also, you should have the 3 character ISO codes for currencies in data market instead of (or as well as) the descriptions. Nobody is going to link data on description fields.</P><H2>Steps to Reproduce</H2><H2>Description</H2><P>When loading data from data market into an existing data model, the data profiling does not seem to work. Regardless of whether i load the data from data market first or second. see steps below. Also, you should have the 3 character ISO codes for currencies in data market instead of (or as well as) the descriptions. Nobody is going to link data on description fields.</P><H2>Steps to Reproduce</H2><P>I have loaded a data model with sales data. There is a column named Base Currency in my data model. It contains the value "US dollar' in every row, as set by the following SQL&nbsp; "update order_details set [Base currency] = 'US dollar'"</P><P></P><P>I loaded this data up into my app from a SQL DB using data profiler. That all worked very nicely.</P><P></P><P>i then load up the 3X3 currency data. There is a column that is identical and it contains many matching values. But no profile suggestions are generated at all.</P><P></P><P>So I then load up the currency data from data market first. I then load up my data from SQL and profile it. When it gets to the currency data it finds that there is a matching column, but for some reason it does not see the values at matching. It finds zero % matches. Please see the image below.</P><P></P><P><IMG alt="Data Profiling.png" class="jive-image image-1" src="/legacyfs/online/89579_Data Profiling.png" style="height: 279px; width: 620px;" /></P></BODY></HTML> Tue, 16 Jun 2015 08:12:57 GMT Lee_Matthews 2015-06-16T08:12:57Z Profiling of Data Market Data not working https://community.qlik.com/t5/QlikView/Profiling-of-Data-Market-Data-not-working/m-p/829504#M469861 <HTML><HEAD></HEAD><BODY><H2>Description</H2><P>When loading data from data market into an existing data model, the data profiling does not seem to work. Regardless of whether i load the data from data market first or second. see steps below. Also, you should have the 3 character ISO codes for currencies in data market instead of (or as well as) the descriptions. Nobody is going to link data on description fields.</P><H2>Steps to Reproduce</H2><H2>Description</H2><P>When loading data from data market into an existing data model, the data profiling does not seem to work. Regardless of whether i load the data from data market first or second. see steps below. Also, you should have the 3 character ISO codes for currencies in data market instead of (or as well as) the descriptions. Nobody is going to link data on description fields.</P><H2>Steps to Reproduce</H2><P>I have loaded a data model with sales data. There is a column named Base Currency in my data model. It contains the value "US dollar' in every row, as set by the following SQL&nbsp; "update order_details set [Base currency] = 'US dollar'"</P><P></P><P>I loaded this data up into my app from a SQL DB using data profiler. That all worked very nicely.</P><P></P><P>i then load up the 3X3 currency data. There is a column that is identical and it contains many matching values. But no profile suggestions are generated at all.</P><P></P><P>So I then load up the currency data from data market first. I then load up my data from SQL and profile it. When it gets to the currency data it finds that there is a matching column, but for some reason it does not see the values at matching. It finds zero % matches. Please see the image below.</P><P></P><P><IMG alt="Data Profiling.png" class="jive-image image-1" src="/legacyfs/online/89579_Data Profiling.png" style="height: 279px; width: 620px;" /></P></BODY></HTML> Tue, 16 Jun 2015 08:12:57 GMT https://community.qlik.com/t5/QlikView/Profiling-of-Data-Market-Data-not-working/m-p/829504#M469861 Lee_Matthews 2015-06-16T08:12:57Z