Can we create Views in Alteryx?
And just a thing : you cannot create a view in sap hana based on sql server... this is not a limit of Alteryx, that's just how views work And that's because you can't query sql server in SAPhana.
Hey @rama533,
The result of an Alteryx workflow is essentially a view. It is the result of a query executed on a table.
What exactly is your question? And are you even referring to SQL views or to smth different?
Hi @rama533 , after connecting to SAP HANA through an Input Data tool, you can choose to query it through custom SQL. To do this, select the SQL Editor tab after connecting to SAP HANA:
Hope this helps!
Hi @FinnCharlton
Unable to create view in InputData tool.Please see the screen shot ..
Hi @rama533 , not sure you can actually create a view using the Input Data tool, I thought you were just trying to execute the query. Why are you trying to create a view with Alteryx and not directly in SAP HANA? I would look into the In-DB tools for this use case: https://help.alteryx.com/20231/designer/database-overview
Thank you @FinnCharlton , Do you have any Idea about this error? Can't we use string_split function in a query in Alteryx?
I was trying to execute the View Query in SQlEditor in output data tool but getting this error at string_split function is not a valid function/procedure
Hello Rama,Fast answer : you can't create view instead of table..Longest answer : but you can use my macro with only three parameters : an in-memory connection, the view name and the select query.Please note that it can also be a good idea for this ideahttps://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/In-DB-Create-View/idi-p/157886
Best regards,Simon
Hi @ simonaubert_bd,
Thank you for the reply , need some more clarification
for example My view name is "dvwSou_Award"
Our source is "aka:SQLServer" and destination is "SAP HANA connection string"
Query of the view is :--
CREATE VIEW dvwSou_AwardASSELECT[Awarding Code] = A.mentCode,[Org Path Id] = A.PathId,
etc 200lines are there
..
what should I give in the three textboxes while running in the interface designer. please explain with my examples..
where should I give source connection string and destination connection string
Please see the screenshots are action tools "replace specific string "correct?
