<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How select fields to be onboarded quickly in Catalog and Lineage</title>
    <link>https://community.qlik.com/t5/Catalog-and-Lineage/How-select-fields-to-be-onboarded-quickly/m-p/1967100#M830</link>
    <description>&lt;P&gt;Hi All,&lt;/P&gt;
&lt;P&gt;we're using &lt;LI-PRODUCT title="Qlik Catalog" id="qlikCatalog"&gt;&lt;/LI-PRODUCT&gt;&amp;nbsp;and we need to onboard huge tables as entities. There are table that contains more than 400 fields and we would like to import just a subset of this.&lt;/P&gt;
&lt;P&gt;The only way to achieve this seems to be to select manually the checkbox for each field, but in our case this is not feasible (if I need just 100/400 I cannot do this manually).&lt;/P&gt;
&lt;P&gt;Playing with the entity properties (in the &lt;STRONG&gt;Source module&lt;/STRONG&gt;) I found the&amp;nbsp;&lt;STRONG&gt;src.file.glob&lt;/STRONG&gt;. Here there is the SQL statement and adding a where condition works, indeed only the filtered data is imported.&lt;/P&gt;
&lt;P&gt;Unfortunately this does not work when the SQL statement is modified to get a subset of fields. Seems the system keep somewhere the list of fields selected in the wizard (in the load log I find the message expected 400 fields but found 100).&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Please, can you help me?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks a lot!&lt;/P&gt;
&lt;P&gt;&lt;EM&gt;Saverio&lt;/EM&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 10 Aug 2022 13:08:26 GMT</pubDate>
    <dc:creator>saveriospa</dc:creator>
    <dc:date>2022-08-10T13:08:26Z</dc:date>
    <item>
      <title>How select fields to be onboarded quickly</title>
      <link>https://community.qlik.com/t5/Catalog-and-Lineage/How-select-fields-to-be-onboarded-quickly/m-p/1967100#M830</link>
      <description>&lt;P&gt;Hi All,&lt;/P&gt;
&lt;P&gt;we're using &lt;LI-PRODUCT title="Qlik Catalog" id="qlikCatalog"&gt;&lt;/LI-PRODUCT&gt;&amp;nbsp;and we need to onboard huge tables as entities. There are table that contains more than 400 fields and we would like to import just a subset of this.&lt;/P&gt;
&lt;P&gt;The only way to achieve this seems to be to select manually the checkbox for each field, but in our case this is not feasible (if I need just 100/400 I cannot do this manually).&lt;/P&gt;
&lt;P&gt;Playing with the entity properties (in the &lt;STRONG&gt;Source module&lt;/STRONG&gt;) I found the&amp;nbsp;&lt;STRONG&gt;src.file.glob&lt;/STRONG&gt;. Here there is the SQL statement and adding a where condition works, indeed only the filtered data is imported.&lt;/P&gt;
&lt;P&gt;Unfortunately this does not work when the SQL statement is modified to get a subset of fields. Seems the system keep somewhere the list of fields selected in the wizard (in the load log I find the message expected 400 fields but found 100).&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Please, can you help me?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks a lot!&lt;/P&gt;
&lt;P&gt;&lt;EM&gt;Saverio&lt;/EM&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 10 Aug 2022 13:08:26 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Catalog-and-Lineage/How-select-fields-to-be-onboarded-quickly/m-p/1967100#M830</guid>
      <dc:creator>saveriospa</dc:creator>
      <dc:date>2022-08-10T13:08:26Z</dc:date>
    </item>
    <item>
      <title>Re: How select fields to be onboarded quickly</title>
      <link>https://community.qlik.com/t5/Catalog-and-Lineage/How-select-fields-to-be-onboarded-quickly/m-p/2109967#M1056</link>
      <description>&lt;P&gt;You'll get faster credentials. You'll just have something else fall by the wayside that's not tracked. And then someone will change their metrics again.&lt;/P&gt;</description>
      <pubDate>Fri, 25 Aug 2023 15:42:25 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Catalog-and-Lineage/How-select-fields-to-be-onboarded-quickly/m-p/2109967#M1056</guid>
      <dc:creator>demein</dc:creator>
      <dc:date>2023-08-25T15:42:25Z</dc:date>
    </item>
  </channel>
</rss>

