topic Re: Convert sql to Qlikview script in QlikView

topic Re: Convert sql to Qlikview script in QlikView https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233846#M869990 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can simply run this sql script using qlikview and load the data into one table..</P><P></P><P>Table:</P><P>Load *</P><P>Sql </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SELECT</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DISC_ALL_OS.HOST_ID as 'MachineID',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SW_MAN.MANUFACTURER as 'OS Manufacturer',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_SW_PRODUCT.SOFTWARE as 'OS Name',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_SW_EDITION.EDITION as 'OS Edition',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CASE WHEN DISC_CS_CAT_MAP.VIRTUAL=1 THEN 'Yes' WHEN DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID IS NOT NULL THEN 'No' ELSE 'N/A' END as 'Is Virtual',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DISC_ALL_OS.HARDWARE as 'Discovered - Hardware',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HW_MAN.MANUFACTURER as 'Manufacturer',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_HW_PRODUCT.PRODUCT as 'Product',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_HW_MODEL.MODEL as 'Model',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C1.CAT_CPU_MODEL as 'CPU Model',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CASE DISC_ALL_OS.IS_UNIQUE WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END as 'Is Unique',</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM DISC_ALL_OS</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN DISC_OS_CAT_MAP ON  DISC_OS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_OS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_OS_CAT_MAP.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_PRODUCT ON DISC_OS_CAT_MAP.CAT_SW_PRODUCT_ID=CAT_SW_PRODUCT.CAT_SW_PRODUCT_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_VERSION ON DISC_OS_CAT_MAP.CAT_SW_VERSION_ID=CAT_SW_VERSION.CAT_SW_VERSION_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_VERSION_GROUP ON CAT_SW_VERSION.CAT_SW_VERSION_GROUP_ID=CAT_SW_VERSION_GROUP.CAT_SW_VERSION_GROUP_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_EDITION ON DISC_OS_CAT_MAP.CAT_SW_EDITION_ID=CAT_SW_EDITION.CAT_SW_EDITION_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_RELEASE ON DISC_OS_CAT_MAP.CAT_SW_RELEASE_ID=CAT_SW_RELEASE.CAT_SW_RELEASE_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_MANUFACTURER SW_MAN ON DISC_OS_CAT_MAP.CAT_MANUFACTURER_ID=SW_MAN.CAT_MANUFACTURER_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN DISC_CS_CAT_MAP ON  DISC_CS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_CS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_HW_PRODUCT ON DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID=CAT_HW_PRODUCT.CAT_HW_PRODUCT_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_HW_MODEL ON DISC_CS_CAT_MAP.CAT_HW_MODEL_ID=CAT_HW_MODEL.CAT_HW_MODEL_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_MANUFACTURER HW_MAN ON DISC_CS_CAT_MAP.CAT_MANUFACTURER_ID=HW_MAN.CAT_MANUFACTURER_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN MATCH_HOST_CPU C1 ON  C1.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AND C1.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AND C1.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">WHERE DISC_ALL_OS.INVENTORY_ID=$inventory_id$</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  AND DISC_ALL_OS.task_id = $task_id$</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">;</P></BODY></HTML> Mon, 28 Nov 2016 06:44:30 GMT sushil353 2016-11-28T06:44:30Z Convert sql to Qlikview script https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233845#M869989 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to convert SQL to Qlikview script. Can you please tell me how can I achieve this.</P><P></P><P>My SQL script is this :</P><P></P><P>SELECT </P><P> DISC_ALL_OS.HOST_ID as 'MachineID',</P><P> SW_MAN.MANUFACTURER as 'OS Manufacturer',</P><P> CAT_SW_PRODUCT.SOFTWARE as 'OS Name',</P><P> CAT_SW_EDITION.EDITION as 'OS Edition',</P><P> CASE WHEN DISC_CS_CAT_MAP.VIRTUAL=1 THEN 'Yes' WHEN DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID IS NOT NULL THEN 'No' ELSE 'N/A' END as 'Is Virtual',</P><P> DISC_ALL_OS.HARDWARE as 'Discovered - Hardware',</P><P> HW_MAN.MANUFACTURER as 'Manufacturer',</P><P> CAT_HW_PRODUCT.PRODUCT as 'Product',</P><P> CAT_HW_MODEL.MODEL as 'Model',</P><P> C1.CAT_CPU_MODEL as 'CPU Model',</P><P> CASE DISC_ALL_OS.IS_UNIQUE WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END as 'Is Unique',</P><P></P><P>FROM DISC_ALL_OS </P><P>LEFT JOIN DISC_OS_CAT_MAP ON  DISC_OS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P>       AND DISC_OS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P>       AND DISC_OS_CAT_MAP.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P>LEFT JOIN CAT_SW_PRODUCT ON DISC_OS_CAT_MAP.CAT_SW_PRODUCT_ID=CAT_SW_PRODUCT.CAT_SW_PRODUCT_ID </P><P>LEFT JOIN CAT_SW_VERSION ON DISC_OS_CAT_MAP.CAT_SW_VERSION_ID=CAT_SW_VERSION.CAT_SW_VERSION_ID</P><P>LEFT JOIN CAT_SW_VERSION_GROUP ON CAT_SW_VERSION.CAT_SW_VERSION_GROUP_ID=CAT_SW_VERSION_GROUP.CAT_SW_VERSION_GROUP_ID </P><P>LEFT JOIN CAT_SW_EDITION ON DISC_OS_CAT_MAP.CAT_SW_EDITION_ID=CAT_SW_EDITION.CAT_SW_EDITION_ID </P><P>LEFT JOIN CAT_SW_RELEASE ON DISC_OS_CAT_MAP.CAT_SW_RELEASE_ID=CAT_SW_RELEASE.CAT_SW_RELEASE_ID </P><P>LEFT JOIN CAT_MANUFACTURER SW_MAN ON DISC_OS_CAT_MAP.CAT_MANUFACTURER_ID=SW_MAN.CAT_MANUFACTURER_ID </P><P>LEFT JOIN DISC_CS_CAT_MAP ON  DISC_CS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P>       AND DISC_CS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P>       AND DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P>LEFT JOIN CAT_HW_PRODUCT ON DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID=CAT_HW_PRODUCT.CAT_HW_PRODUCT_ID</P><P>LEFT JOIN CAT_HW_MODEL ON DISC_CS_CAT_MAP.CAT_HW_MODEL_ID=CAT_HW_MODEL.CAT_HW_MODEL_ID</P><P>LEFT JOIN CAT_MANUFACTURER HW_MAN ON DISC_CS_CAT_MAP.CAT_MANUFACTURER_ID=HW_MAN.CAT_MANUFACTURER_ID</P><P>LEFT JOIN MATCH_HOST_CPU C1 ON  C1.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P> AND C1.TASK_ID=DISC_ALL_OS.TASK_ID</P><P> AND C1.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P>WHERE DISC_ALL_OS.INVENTORY_ID=$inventory_id$</P><P>  AND DISC_ALL_OS.task_id = $task_id$</P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233845#M869989 2020-11-25T16:16:04Z Re: Convert sql to Qlikview script https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233846#M869990 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can simply run this sql script using qlikview and load the data into one table..</P><P></P><P>Table:</P><P>Load *</P><P>Sql </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SELECT</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DISC_ALL_OS.HOST_ID as 'MachineID',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SW_MAN.MANUFACTURER as 'OS Manufacturer',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_SW_PRODUCT.SOFTWARE as 'OS Name',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_SW_EDITION.EDITION as 'OS Edition',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CASE WHEN DISC_CS_CAT_MAP.VIRTUAL=1 THEN 'Yes' WHEN DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID IS NOT NULL THEN 'No' ELSE 'N/A' END as 'Is Virtual',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DISC_ALL_OS.HARDWARE as 'Discovered - Hardware',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HW_MAN.MANUFACTURER as 'Manufacturer',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_HW_PRODUCT.PRODUCT as 'Product',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CAT_HW_MODEL.MODEL as 'Model',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">C1.CAT_CPU_MODEL as 'CPU Model',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">CASE DISC_ALL_OS.IS_UNIQUE WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END as 'Is Unique',</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">FROM DISC_ALL_OS</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN DISC_OS_CAT_MAP ON  DISC_OS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_OS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_OS_CAT_MAP.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_PRODUCT ON DISC_OS_CAT_MAP.CAT_SW_PRODUCT_ID=CAT_SW_PRODUCT.CAT_SW_PRODUCT_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_VERSION ON DISC_OS_CAT_MAP.CAT_SW_VERSION_ID=CAT_SW_VERSION.CAT_SW_VERSION_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_VERSION_GROUP ON CAT_SW_VERSION.CAT_SW_VERSION_GROUP_ID=CAT_SW_VERSION_GROUP.CAT_SW_VERSION_GROUP_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_EDITION ON DISC_OS_CAT_MAP.CAT_SW_EDITION_ID=CAT_SW_EDITION.CAT_SW_EDITION_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_SW_RELEASE ON DISC_OS_CAT_MAP.CAT_SW_RELEASE_ID=CAT_SW_RELEASE.CAT_SW_RELEASE_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_MANUFACTURER SW_MAN ON DISC_OS_CAT_MAP.CAT_MANUFACTURER_ID=SW_MAN.CAT_MANUFACTURER_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN DISC_CS_CAT_MAP ON  DISC_CS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_CS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">       AND DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_HW_PRODUCT ON DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID=CAT_HW_PRODUCT.CAT_HW_PRODUCT_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_HW_MODEL ON DISC_CS_CAT_MAP.CAT_HW_MODEL_ID=CAT_HW_MODEL.CAT_HW_MODEL_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN CAT_MANUFACTURER HW_MAN ON DISC_CS_CAT_MAP.CAT_MANUFACTURER_ID=HW_MAN.CAT_MANUFACTURER_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LEFT JOIN MATCH_HOST_CPU C1 ON  C1.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AND C1.TASK_ID=DISC_ALL_OS.TASK_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">AND C1.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">WHERE DISC_ALL_OS.INVENTORY_ID=$inventory_id$</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  AND DISC_ALL_OS.task_id = $task_id$</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">;</P></BODY></HTML> Mon, 28 Nov 2016 06:44:30 GMT https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233846#M869990 sushil353 2016-11-28T06:44:30Z Re: Convert sql to Qlikview script https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233847#M869991 <HTML><HEAD></HEAD><BODY><P>Hi Nikhil,</P><P></P><P>You can add following before your SQL script:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Table_Name:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Load *</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sql</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SELECT</P></BODY></HTML> Mon, 28 Nov 2016 06:57:58 GMT https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233847#M869991 Anonymous 2016-11-28T06:57:58Z Re: Convert sql to Qlikview script https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233848#M869992 <HTML><HEAD></HEAD><BODY><P>You may try something like below</P><P></P><P><STRONG style="color: #ff0000;">LOAD</STRONG></P><P><STRONG>DISC_ALL_OS.HOST_ID as 'MachineID',</STRONG></P><P><STRONG>SW_MAN.MANUFACTURER as 'OS Manufacturer',</STRONG></P><P><STRONG>CAT_SW_PRODUCT.SOFTWARE as 'OS Name',</STRONG></P><P><STRONG>CAT_SW_EDITION.EDITION as 'OS Edition',</STRONG></P><P><STRONG style="color: #ff0000;">If(DISC_CS_CAT_MAP.VIRTUAL=1, 'Yes',If(DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID <> Null(), 'No'), 'N/A') as 'Is Virtual',</STRONG></P><P><STRONG>DISC_ALL_OS.HARDWARE as 'Discovered - Hardware',</STRONG></P><P><STRONG>HW_MAN.MANUFACTURER as 'Manufacturer',</STRONG></P><P><STRONG>CAT_HW_PRODUCT.PRODUCT as 'Product',</STRONG></P><P><STRONG>CAT_HW_MODEL.MODEL as 'Model',</STRONG></P><P><STRONG>C1.CAT_CPU_MODEL as 'CPU Model',</STRONG></P><P><STRONG style="color: #ff0000;">If(DISC_ALL_OS.IS_UNIQUE = 1 , 'Yes' 'No' ) as 'Is Unique'</STRONG></P><P><STRONG>FROM DISC_ALL_OS</STRONG></P><P><STRONG>LEFT JOIN <SPAN style="color: #ff0000;">(</SPAN>DISC_OS_CAT_MAP) <SPAN style="color: #ff0000;">where </SPAN> DISC_OS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</STRONG></P><P><STRONG>      and DISC_OS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</STRONG></P><P><STRONG>      and DISC_OS_CAT_MAP.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_SW_PRODUCT) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_OS_CAT_MAP.CAT_SW_PRODUCT_ID=CAT_SW_PRODUCT.CAT_SW_PRODUCT_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_SW_VERSION) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_OS_CAT_MAP.CAT_SW_VERSION_ID=CAT_SW_VERSION.CAT_SW_VERSION_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_SW_VERSION_GROUP) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>CAT_SW_VERSION.CAT_SW_VERSION_GROUP_ID=CAT_SW_VERSION_GROUP.CAT_SW_VERSION_GROUP_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_SW_EDITION) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_OS_CAT_MAP.CAT_SW_EDITION_ID=CAT_SW_EDITION.CAT_SW_EDITION_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_SW_RELEASE) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_OS_CAT_MAP.CAT_SW_RELEASE_ID=CAT_SW_RELEASE.CAT_SW_RELEASE_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_MANUFACTURER SW_MAN) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_OS_CAT_MAP.CAT_MANUFACTURER_ID=SW_MAN.CAT_MANUFACTURER_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>DISC_CS_CAT_MAP) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_CS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</STRONG></P><P><STRONG>      and DISC_CS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</STRONG></P><P><STRONG>      and DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_HW_PRODUCT) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID=CAT_HW_PRODUCT.CAT_HW_PRODUCT_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_HW_MODEL) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_CS_CAT_MAP.CAT_HW_MODEL_ID=CAT_HW_MODEL.CAT_HW_MODEL_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>CAT_MANUFACTURER HW_MAN) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>DISC_CS_CAT_MAP.CAT_MANUFACTURER_ID=HW_MAN.CAT_MANUFACTURER_ID</STRONG></P><P><STRONG>LEFT JOIN <STRONG style="color: #ff0000; font-size: 13.3333px;">(</STRONG>MATCH_HOST_CPU C1) <STRONG style="font-size: 13.3333px;"><SPAN style="color: #ff0000;">where </SPAN> </STRONG>C1.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</STRONG></P><P><STRONG>and C1.TASK_ID=DISC_ALL_OS.TASK_ID</STRONG></P><P><STRONG>and C1.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</STRONG></P><P><STRONG>and DISC_ALL_OS.INVENTORY_ID=$inventory_id$ </STRONG><STRONG style="font-size: 10pt;">and DISC_ALL_OS.task_id = $task_id$</STRONG></P></BODY></HTML> Mon, 28 Nov 2016 07:08:33 GMT https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233848#M869992 Anil_Babu_Samineni 2016-11-28T07:08:33Z Re: Convert sql to Qlikview script https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233849#M869993 <HTML><HEAD></HEAD><BODY><P>Hi Nikhil</P><P></P><P></P><P>Try this:</P><P></P><P>load</P><P>DISC_ALL_OS.HOST_ID as [MachineID],</P><P>SW_MAN.MANUFACTURER as [OS Manufacturer],</P><P>CAT_SW_PRODUCT.SOFTWARE as [OS Name],</P><P>CAT_SW_EDITION.EDITION as [OS Edition],</P><P>If(DISC_CS_CAT_MAP.VIRTUAL=1, 'Yes',If(DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID <> Null(), 'No', 'N/A')) as [Is Virtual],</P><P>DISC_ALL_OS.HARDWARE as [Discovered - Hardware],</P><P>HW_MAN.MANUFACTURER as [Manufacturer],</P><P>CAT_HW_PRODUCT.PRODUCT as [Product],</P><P>CAT_HW_MODEL.MODEL as [Model],</P><P>C1.CAT_CPU_MODEL as [CPU Model],</P><P>If(DISC_ALL_OS.IS_UNIQUE = 1 , 'Yes' ,'No' ) as [Is Unique]</P><P>FROM DISC_ALL_OS;</P><P>LEFT JOIN</P><P>load </P><P>(DISC_OS_CAT_MAP) </P><P>where DISC_OS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P>      and DISC_OS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P>      and DISC_OS_CAT_MAP.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID;</P><P>LEFT JOIN </P><P>load(CAT_SW_PRODUCT) where DISC_OS_CAT_MAP.CAT_SW_PRODUCT_ID=CAT_SW_PRODUCT.CAT_SW_PRODUCT_ID;</P><P>LEFT JOIN </P><P>load(CAT_SW_VERSION) where DISC_OS_CAT_MAP.CAT_SW_VERSION_ID=CAT_SW_VERSION.CAT_SW_VERSION_ID;</P><P>LEFT JOIN </P><P>load(CAT_SW_VERSION_GROUP) where CAT_SW_VERSION.CAT_SW_VERSION_GROUP_ID=CAT_SW_VERSION_GROUP.CAT_SW_VERSION_GROUP_ID;</P><P>LEFT JOIN </P><P>load(CAT_SW_EDITION) where DISC_OS_CAT_MAP.CAT_SW_EDITION_ID=CAT_SW_EDITION.CAT_SW_EDITION_ID;</P><P>LEFT JOIN </P><P>load(CAT_SW_RELEASE) where DISC_OS_CAT_MAP.CAT_SW_RELEASE_ID=CAT_SW_RELEASE.CAT_SW_RELEASE_ID;</P><P>LEFT JOIN </P><P>load([CAT_MANUFACTURER SW_MAN]) where DISC_OS_CAT_MAP.CAT_MANUFACTURER_ID=SW_MAN.CAT_MANUFACTURER_ID;</P><P>LEFT JOIN </P><P>load(DISC_CS_CAT_MAP) where DISC_CS_CAT_MAP.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P>      and DISC_CS_CAT_MAP.TASK_ID=DISC_ALL_OS.TASK_ID</P><P>      and DISC_CS_CAT_MAP.COMPUTERSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID;</P><P>LEFT JOIN </P><P>load(CAT_HW_PRODUCT) where DISC_CS_CAT_MAP.CAT_HW_PRODUCT_ID=CAT_HW_PRODUCT.CAT_HW_PRODUCT_ID;</P><P>LEFT JOIN </P><P>load(CAT_HW_MODEL) where DISC_CS_CAT_MAP.CAT_HW_MODEL_ID=CAT_HW_MODEL.CAT_HW_MODEL_ID;</P><P>LEFT JOIN </P><P>load([CAT_MANUFACTURER HW_MAN]) where DISC_CS_CAT_MAP.CAT_MANUFACTURER_ID=HW_MAN.CAT_MANUFACTURER_ID;</P><P>LEFT JOIN </P><P>load([MATCH_HOST_CPU C1]) where C1.INVENTORY_ID=DISC_ALL_OS.INVENTORY_ID</P><P>and C1.TASK_ID=DISC_ALL_OS.TASK_ID</P><P>and C1.OPERATINGSYSTEM_ID=DISC_ALL_OS.OPERATINGSYSTEM_ID</P><P>and DISC_ALL_OS.INVENTORY_ID=$inventory_id$ and DISC_ALL_OS.task_id = $task_id$;</P><P></P><P>Regards</P><P>Dinesh</P></BODY></HTML> Mon, 28 Nov 2016 09:52:26 GMT https://community.qlik.com/t5/QlikView/Convert-sql-to-Qlikview-script/m-p/1233849#M869993 dineshm030 2016-11-28T09:52:26Z