This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
in Qlik I have the following script which reads from the DBA_TABLES (oracle) the names of the tables that I want then for each row I got in the result set I read all columns and all rows and then save each table in a QVD or QVX
following is my Qlik Script, can someone advise on how to accomplish this via the Alteryx workflow?: jde_tables:
SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE ( OWNER = 'PRODCTL' and TABLE_NAME IN ('F0005') ) OR ( OWNER = 'PRODDTA' and TABLE_NAME IN ('F42003','F0150','F58HH999') ) ;
for i=0 to NoOfRows('jde_tables')-1
let vTableName = Peek('TABLE_NAME',$(i),'jde_tables'); LET vOwner = Peek('OWNER',$(i),'jde_tables'); let vTableName = '$(vOwner)' &'.' & '$(vTableName)';
if left('$(vTableName)',1) = '@' then let vTableName = '"' & '$(vTableName)' & '"'; endif let vQlikTableName = replace(Replace('$(vTableName)','"',''),'@','');
$(vQlikTableName): load *; sql select * from $(vTableName);
store $(vQlikTableName) into $(vQvd_Files_Location)$(vQlikTableName).qvd; drop table $(vQlikTableName);
If you're just starting off with Alteryx, you'll need to learn up on the different type of Macro's you can create, more specifically, BATCH macro for your use case. The link is the search results, but I'd encourage you to review the Live Training (Macros) in the Academy page.
Hope this gives you the information you're looking for to accomplish this!