topic Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)". in Alteryx Designer Desktop Discussions

Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

PiyushJain — Thu, 23 Dec 2021 07:28:38 GMT

Hi Team,

Before starting my issue/ error. Please refer below workflow connection. My workflow connection is as below:

Datasource: 1) Database 2) .Json file

These 2 data sources are connected through Bitbucket.

Macro Container: This Container connected through. .Json and sql file and after preprocessing workflow, this macro container creates one .csv file.

THEN macro container used to pull/ proceed data and published report to some reporting portal with the help of predefined API.

Now the issue is:

I am able to get expected records from sql.

But when workflow reached to Macro container..it falied with below error.

status: 400,status reason : bad request

Message: Invalid csv provides during upload

Msg= There are too few coloumns

Also able to see /n are added to the end of a each row by the macro .

I am also geeting below error in multifield formula tool

" Formula: tried to apply string operator to numeric value ( REPLACE)".

My expressions is as below:

Replace ( [ _CurrentField_] ,' ' ,'T')

Please help to understand the meaning of that and how to resolved that.

Regards

Piyush J

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

DavidP — Thu, 23 Dec 2021 10:10:35 GMT

Hi @PiyushJain

My guess is that the csv that is created is different from what the upload API is expecting, but it's hard to tell without being able to follow the logic through.

As for the second error, I can offer some thoughts.

If you look at the configuration of the multi-field formula, you can see at the very top there is a Select with a dropdown beside it. Here you tell the tool which type of fields you want to modify.

The Replace formula can only be used with Text fields, so if Numeric fields are included in the list, you'll get the error you're seeing. From the dropdown, you should select "Text" and then you'll get the option below that to pick the specific fields that you want modified. I'm guessing from your formula that you're looking to replace the space between the date and time in a datetime field with a T, so make sure the right fields are selected.

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

PiyushJain — Thu, 23 Dec 2021 14:22:56 GMT

Hi David,

I agree with your points.

I am not able to see any .csv,that's why not able to understand where is the exact issue.

Regarding Second Error: below is the default set up in my Multifiled formula tool:

Select Dropdown selected " Datetime"

Selected coloumns are as below

Date

Dynamic or unknown fields

When i select "Text" option this " date" column is disappear.

Is " Date " coloumn create issue?

Regarding replace syntax ,i agree with you that

it is related to date and time as you also mentioned .

So not sure what else i need to check.

Please advise

Regards

Piyush

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

binu_acs — Thu, 23 Dec 2021 14:33:41 GMT

@PiyushJain for the second error please the below formula

Replace(ToString([_CurrentField_])," ","T")

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

DavidP — Thu, 23 Dec 2021 14:43:20 GMT

One more thing to consider with the multi field formula. If the data type is DateTime, you can't insert a T. For that to work, you also have to tell the multi field formula to change the data type to string

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

PiyushJain — Thu, 23 Dec 2021 17:59:34 GMT

Hi Binuacs,

I used syntax provided by you and now first error resolved.

But 1 more warning came ( see below)

Date: "2012-01-05T00:00:00" is not a valid datetime

ALSO 2nd error is still there...

2nd error :

Status : 400.... ( please refer my main page)

I am sharing my multifield formula setup, please correct me if my setup is wrong.

In dropdown option i am selecting " Datetime".

Fields are : date and dynamic or unknown fields

Change output to : V_WString

Expressions: Replace( ToString........)

Please advise.

Regards

Piyush Jain

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

PiyushJain — Thu, 23 Dec 2021 18:01:37 GMT

Hi David,

Tired to understand, but not able to catch completely.

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

binu_acs — Fri, 24 Dec 2021 07:56:04 GMT

@PiyushJain "2012-01-05T00:00:00" is not a valid DateTime in Alteryx, to avoid the warning change your settings like below

Re: Error : Formula: tried to apply string operator to numeric value ( REPLACE)".

PiyushJain — Sat, 25 Dec 2021 17:11:26 GMT

Hi Binuacs/ Team,

Thanks for your help. Based on your suggestion i am able to resolve first error.

But still facing 2nd error as below:

When workflow reached to Macro container..it falied with below error.

status: 400,status reason : bad request

Message: Invalid csv provides during upload

Msg= There are too few coloumns

Also able to see /n are added to the end of a each row by the macro .

Please help me to understand the meaning of that and how to resolved that.

Regards

Piyush J