Hello Experts ,
Very new to Alteryx so need your help
I have a file with 2 columns -Source, Target and n rows .
I want to dynamically create table AS table name=sourcefile.Target and structure/data of target table should be same as sourcefile.Source
Customer, Customer copy
Product, Product Copy
Output : 2 new tables are created Customer copy and Product copy . Customer copy is replica of Customer and so on.
I was trying to put CTAS in Post Sql but how to pass attribute value dynamically in post sql .