Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a sql query that works fine when I run this in my SQLYog app.
SELECT * FROM SW_PROD_RELEASE WHERE SWSUBTYPE IN ("Router","Data Switch","Firewall","Voice Switch");
I would like to use this in my Qlikview app to pull out what is in the ()
Below is my Load and SQL statements in Qlikview.
Note: below is only part of the load and sql statements. If more is needed I may be able to provide it but I think this is enough.
I would prefer to run all my queries in the code here rather than using dimensions or expressions
QLIKVIEW Code Below
Flatfile:
LOAD
ASSET_CLASS
SQL
SELECT
PN.SWSUBTYPE ASSET_CLASS, (NOTE this is where the mapping happens for the sub-type to asset_class in the load statement)
FROM GPS.SW_PROD_RELEASE PN
My goal is to limit what is being pulled out of the SW_PRODUCT_RELEASE table to what is in () in the SQLYog query.
Thanks in advance.