We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Input tool and delimiters - client/server side

BastianB
5 - Atom

Hello everyone,

I'm having an issue that looks like a quickfix - if you know what to do. Which I don't.

The issue is the following:

I'm using an input tool to read data from a .CSV File and an userinput+update tool to change the delimiter of said input tool to match the file.

It works fine on my client, I can use all kind of .CSV-Files and just select the right delimiter and the workflow works.

Now once I upload it to the server and the interface is now web based, some options don't work anymore.

 

-I take a comma seperated CSV and selected "," as my delimiter and it works

-I take a tab seperated CSV and selected "\t" as my delimiter and it works

-I take a Pipe seperated CSV and selected "|" as my delimiter and it's an error: Parse Error at char(1): Unknown variable "Col1|Col2|Col3"

Same error for semicolon.

 

The thing is, it works all over the same input and update tool. The input is all the same too apart from the delimiters for example:

Col1,Col2,Col3

Col1|Col2|Col3

etc.

 

No white spaces either. Workflow works without error for all types on my client but not on the server.

Any ideas? It's the first time I'm dealing with the server side of things

1 REPLY 1
afv2688
16 - Nebula
16 - Nebula

Hello @BastianB ,

 

I have tried a solution with this kind of interface and seems to work on my server.

 

Could you try to set this up and see if it works for you too?

 

Note: I'm on 2020.4 on both, designer and server

 

Regards