Data parsing from Text file

[Devsadhan86]

Hi All

I am trying to parse the attached txt file into the given output shared. (PFA)

the names of actual data items have been changed due to privacy reason. however, the format is the same.

I went through some of the post shared in the community regarding the parsing of data from text file. i was able to replicate the same logic shared earlier.

the logic works fine where we have data present in the schema table. however, it doesn't work for tables which doesn't contain any information.

the issue is how to tackle this problem.

i have attached the workflow that i have used. when you run the work flow you would observe the in multi row formula has stopped giving correct output after row 11.

ideally the row 12 should have source value as 7 instead of 6.

please feel free to reach out to me with any query, i would try my best to answer them.

additionally, another approach to get the desired output is also welcomed.

looking forward to response.

Happy learning

Dev

[ArtApa · Accepted solution]

Hi @Devsadhan86 - Here is my idea on how you can do that (see my workflow in attachment):

[Devsadhan86]

@ArtApa Thanks a lot for your response. 

Working as designed.

Regards

Dev