Delimited file Import and normalization
Hi everyone, I need to set up a few transformations to normalize a delimited file that will be uploaded by the users, before feeding it to the datasource. I previously worked with FTP folders, and...
Forum Discussion
Hi JJones
I already read the OS documentation but couldn't find very clear information about it.
My problem is that the file that the user will load and that will be fed to the datasource has each account in a separate header, and the values are stored below each account instead of being stored in a dedicated column.
For example:
UD1,UD2,UD3,Acc1,Acc2,Acc3,... (headers)
UD1,UD2,UD3,Amount1,Amount2,Amount3,...
I believe I need to rearrange the content this way:
UD1,UD2,UD3,Acc1,Amount1
UD1,UD2,UD3,Acc2,Amount2
...
but I cannot understand how. My understanding is that parser rules can only be used to modify data that already hit the datasource. Can I use a connector to do that even though the file is loaded manually by the user?