Data type issue - VERY URGENT

[satya04]

I am trying to input 36 files with same schema into Alteryx and perform a summary of transactions to see total value on a monthly basis.

The first row is not the header and I have to adjust it in this way

1. Select tool to rename header

2. Sample tool to exclude first 2 rows so that the data is being pulled from the first row

3. Filter tool to exclude the column headers for the other 35 files which are also obtained through the input tool.

After doing this changes, I have encountered the following issues

1.  Date values appear as null (conversion error for not being a valid date)

2.  Conversion error for ConvError: Select (12): Total Transaction Value ($USDmm, Historical rate): - is not a valid number.

The data type is not working correctly for both the fields "All Transactions Announced Date" and "Total Transaction Value ($USDmn, Historical rate)". Please guide me on how this can be addressed.

[binuacs]

@satya04 can you upload some sample files?

[satya04]

@binuacs Please refer to the attached input files.

[binuacs]

@satya04 After the below steps what are the next steps?

[satya04]

@binuacs present a summarized view of monthly volume. Only the first ("All Transactions Announced Date") and and last column ("Total Transaction Value ($USDmn, Historical rate)) are required for this.

For instance, Jan 2020 had a volume of 250 and so on.

[satya04]

@binuacs 50,008 rows in your workflow would mean 8 additional records for the column headers which has to be filtered out. This along with changing the data type to avoid the conversion error is needed for the final summarization.

[binuacs]

@satya04 I updated the workflow and created two fields at the end for the Transaction  Date and Transaction Amount. You can make changes on this workflow 

[satya04]

@binuacs Thank you for your guidance. I'll take a look now.

[satya04]

@binuacs Thank you for helping me out. Just wanted to check a few things on the workflow.

The container is not contributing towards the output and can be excluded, right?

There is one conversion error message in the formula added for "All Transaction Announced Date1"

Formula (21) DATETIMEPARSE: Cannot convert "-" to a date/time with format "%m/%d/%Y" and language "English":  Expected a number for Month: '-'

Please guide me on this.

[binuacs]

@satya04 you can remove the container

I do not see any error in the workflow. Can you check any "-" is present in your Transaction date field?