How do I handle duplicate column names in my Text Target file?

I am creating a map using text file as Target Connector posting data to an SFTP site where I need to have some column names with the same names. This is for multiple direct deposit account information - when there is more then one then I have to use the same column names over again for the second and third bank account. The issue is that this gives an error.

 

Is there any way to handle having identical column names in this scenario? This is required by the system I am importing to so I have no option to adjust the column names to different values then each other.

 

Here are the column names I need - you will notice that they repeat 3 times with the same values:

Bank Deposit Deduction Code,Bank Deposit Account Number,Bank Deposit Transit/ABA,Bank Full Deposit Flag,Bank Deposit Deduction Code,Bank Deposit Account Number,Bank Deposit Transit/ABA,Bank Full Deposit Flag,Bank Deposit Deduction Code,Bank Deposit Account Number,Bank Deposit Transit/ABA,Bank Full Deposit Flag

 

(12) Answers

Login