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

[PiyushJain]

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

[DavidP]

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.

[PiyushJain]

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

[binuacs]

@PiyushJain for the second error please the below formula

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

Spoiler

[DavidP]

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

[PiyushJain]

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

[PiyushJain]

Hi David,

Tired to understand, but not able to catch completely. 

[binuacs]

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

Spoiler

[PiyushJain]

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