Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to pass column value as parameter in post sql in Alteryx?

5 - Atom

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 


Source File:

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 .



Alteryx Alumni (Retired)

Thank you for your contribution to the Community!

To help make it easier for others to assist, it would be helpful to get some additional information on your Process. Here's what we recommend you include in your reply:

* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?
* What about a Screenshot?
* What does the data look like? (Beginning data vs. Final Output)

Posting for Fastest Possible Solution (https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/t...)

Thank you very much!

Community Moderator