How to read and process this file in alteryx designer. It has multple block of text, I need to segregate them along with their header
@cjaneczko can you please help here
@flying008 can you please help me on this
For multi-block flat files like this in Alteryx, the usual approach is to read the raw file with the Text Input or Input Data tool set to read line by line, then use a Multi-Row Formula tool to tag each line based on whether it matches a header pattern. From there a Record ID plus some filtering logic lets you group and split the blocks into separate streams. Sharing a sample of what the file structure actually looks like would help the community give you a more specific solution.
@stevemarkovick I have attached the expected result, although there is more processing to it
