i am importing an excel file and one SQL file (.txt). There are some field name in excel and those field names are generated using the sql script. i want that the workflow should take input file excel and also one input as SQL file. And in the last just want the output as 2 fields (1 Field name and 2nd Table Name used to refer the field (in the sql file )).
i created the workflow but i am getting the error as the normal table i am able to get, but the table which is used to join and the field sourced from that table are not coming in output.
i am just getting the primary table in the output for even the element which is sourced from join table(refer highlighted row in output.png) ., please help me getting the join table also and please help me how can i create workflow that can entertain , complex queries also with many lines of sql or many joins in query.
Regex i used in the below flow : "(?i)(?:from|join|inner join|left join|right join|full join)\s+([a-zA-Z0-9_\.]+)\s+(?:as\s+)?([a-zA-Z0-9_]+)"
i am putting my initial workflow screenshot , excel screenshot of what output i need in alteryx last stage and my sql file also.
please someone can help...!??
