Can't figure out what my error is

Question

Hi All

One year ago I created an MT535 message reader using Alteryx, as I did not have a program that could read the files properly. 
I saved a "Working" copy and haven't touched it since, but now I am not getting the result that I used to get.

Does anyone have an idea where my error is? (I believe it is somewhere in the data load part in the beginning?)

Further information:
The flow is loading a list of .txt files (80+ normally (only 2 dummys attached)) and is extracting the information needed using the flow. Information is e.g. account number, units (quantity), price and total value.

I do believe, that the error occurs somewhere after the unique identifier, where I would like each of the Tile_Num to represent a row and each of the Tile_sequenceNum to be a column in the corresponding row, so that I can continue to isolate the columns/row needed and finally sort them so each of the rows represent 1 stock/holding of a stock.

I have attached 2x dummy sheets and my flow. Any help or advise would be incredible appreciated.

Kind Regards

MT535 Reader with error.yxmd

20211231-123456-1235-MT535.txt

20211231-123456-1236-MT535.txt

mceleavey · Answer

Hi @Lauritsjust ,

Your formula tool #45 is referring to fields such as "Account" in the formula where you're actually creating those fields. The fields do not exist:

My guess is the format of the file has changed as there is no parsing of the elements within the file.

M.

ChrisTX · Answer

In the Dynamic Rename tool (tool id 36), how do you expect the field [Meta] to be copied to the main data stream?  A Dynamic Rename won't add fields from another data stream, it only renames fields.

Then in the next tool Dynamic Select (tool id 37), you have [Description]="keep", which has zero records in the output anchor.

Chris