community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

reading specific tables from the DBA_TABLES

Highlighted

Hello

I'm new to Alteryx

We are using Alteryx for Qlik 

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:

SQL

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);

next

drop Table jde_tables;

Alteryx Certified Partner

@ali_hijazi,

 

Short answer is yes, Alteryx can do this.

 

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!

 

Jimmy

Labels