Could someone please explain with a workflow how to extract column names from SQL queries within an Excel file using Alteryx?
Input:
Commands Column
Output:
Table Name
Column Name
Could you clarify what you mean by extract column names? These look like delete statements. The first step would be to pull the data into Alteryx by using an Input Data tool which should bring the information into Alteryx in tabular format. It looks like the columns of interest are in the third column of your spreadsheet. Are you trying to see if these exist in the tables in the second column?
Hey @BrandonB
I have a table where the first column contains SQL commands such as DELETE and UPDATE statements. I would like to read each row, identify the table name and column name from that row, and print them in separate columns titled "Table Name" and "Column Name" respectively.