topic Re: analytic app ran on server - is there a way to view a sample of records in a table ? in Alteryx Designer Desktop Discussions

analytic app ran on server - is there a way to view a sample of records in a table ?

wonka1234 — Wed, 07 Jun 2023 13:07:35 GMT

Hi,

I remember seeing records in a table on the server at some point or atleast a sample of records, but not sure where.

Is there a way to view a table of records on the server of an analytic app?

Ie on the sever of a chained app, you click next and at the top of the next page you see:

col 1	col 2	col 3
data	data	data
data	data	data

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

caltang — Wed, 07 Jun 2023 13:25:52 GMT

That happens if you have a Sample Tool attached to your workflow and that you have a Browse Tool on the canvas + enabled on the Alteryx Interface Designer to view the Browse.

Once you run the Analytic App, you will see the sample via the Browse Tool. Is this what you are looking for?

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

wonka1234 — Wed, 07 Jun 2023 13:27:48 GMT

@caltang yes exactly! do you have a sample workflow?

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

caltang — Wed, 07 Jun 2023 13:37:09 GMT

Sure! Here you go.

So, you will notice that in the interface designer, you will need to tick "Browse":

So that after your selections, you'll see this:

Hope it helped!

-Cal

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

wonka1234 — Wed, 07 Jun 2023 13:38:17 GMT

@caltang thx, but how does this look on the server?

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

caltang — Wed, 07 Jun 2023 13:41:15 GMT

You will have to upload it to the Server to see. I do not have access to a Server at the moment.

But your interface tools that you put into your workflow will act as a GUI for your end users to interact with. So that when the task is done, you will need to configure for them to see the results on the server itself.

Actually wait, after reading your query once again I think I misunderstood you. This is what you are looking for:

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Browse-tool-on-the-alteryx-gallery-doesn-t-work/m-p/611673

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

wonka1234 — Wed, 07 Jun 2023 13:47:40 GMT

@caltang yes this is it! trying it but unable to get it to work... I dont know if the results can only be shown on the LAST page of an app or on any page.

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

caltang — Wed, 07 Jun 2023 14:32:50 GMT

Have you tried @Loic's method?

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Browse-tool-on-the-alteryx-gallery-doesn-t-work/m-p/603452/highlight/true#M6781

You will need 2 applications to get this going, this is known as a Chain App. Like so:

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

wonka1234 — Wed, 07 Jun 2023 20:02:26 GMT

@caltang yes ive tried, i belive he is saying it can only be done on the last page of an app.

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

alexnajm — Wed, 07 Jun 2023 20:38:52 GMT

Instead of a Browse tool, use an Output Data tool and output as a .yxdb file. You can then view it on Server, even at different parts of a chained workflow - just make sure you specify this Output Data tool to show in the "Show Results to User" part of Interface Designer!

Re: analytic app ran on server - is there a way to view a sample of records in a table ?

caltang — Thu, 08 Jun 2023 12:37:05 GMT

@wonka1234 have you tried what @alexnajm mentioned? Replace the Browse Tool with and use the Output Tool to YXDB.