I have a pipeline in which I am reading a file and parse it with CSV parser.
David| 18| M
I am able to parse the file but at the end of each record, I would like to append a file name in which record comes.
So reading a file using file reader and copying a file name on copy snap to merge with join but somehow I only see a file name on first record.
I am trying a merge join but it merges output at first record, how do I merge file name on to mapped element ?
So expecting output something like this -
Name Age Gender Filename
David 18 M names.csv
Julie 20 F names.csv