# Delimited File - Merge two files **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** sailpoint-identity-security\ **Created:** [October 13, 2023, 11:27am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117 "2023-10-13T11:27:46Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![maheshtare](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@maheshtare](https://developer.sailpoint.com/discuss/u/maheshtare)\ **Post date:** [October 13, 2023, 11:27am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/1 "2023-10-13T11:27:46Z")
Hi All, We have a requirement to merge two csv files into one and use that for aggregation. How can we do that in IDN. ---
**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\ **Post date:** [October 13, 2023, 12:23pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/2 "2023-10-13T12:23:13Z")
Are you using File upload utility ? ---
**Author:** ![maheshtare](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@maheshtare](https://developer.sailpoint.com/discuss/u/maheshtare)\ **Post date:** [October 13, 2023, 12:27pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/3 "2023-10-13T12:27:19Z")
No, we are using delimiter file connector for this. ---
**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\ **Post date:** [October 13, 2023, 12:28pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/4 "2023-10-13T12:28:29Z")
Are you importing the file manually then to aggregate the CSV file ? ---
**Author:** ![maheshtare](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@maheshtare](https://developer.sailpoint.com/discuss/u/maheshtare)\ **Post date:** [October 13, 2023, 12:32pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/5 "2023-10-13T12:32:42Z")
We haven’t onboarded this app yet but looking for best ways to do it and handle this use case in SailPoint. For rest of the flat file applications we are manually uploading file using delimited file connector. ---
**Author:** ![KRM7](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/krm7/32/2685_2.png) [@KRM7](https://developer.sailpoint.com/discuss/u/KRM7)\ **Post date:** [October 13, 2023, 12:44pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/6 "2023-10-13T12:44:55Z")
Ok. If you are going to upload file manually every time you need to aggregate, then you can merge the files and upload them as a single file, you can do manually or use some custom PowerShell or Python or any other script of your choice. But don’t you think, if there is a way to aggregate CSV files automatically without manual intervention, it’s cool rite. Yes, We have solution for that as well. File Upload utility, refer to below docs for more information. [IdentityNow File Upload Utility - Compass (sailpoint.com)](https://community.sailpoint.com/t5/Professional-Services/IdentityNow-File-Upload-Utility/ta-p/76392) [File Upload Utility - CoLab / Community Tools - SailPoint Developer Community Forum](https://developer.sailpoint.com/discuss/t/file-upload-utility/18181) Thanks Krish ---
**Author:** ![atarodia](https://avatars.discourse-cdn.com/v4/letter/a/f17d59/32.png) [@atarodia](https://developer.sailpoint.com/discuss/u/atarodia)\ **Post date:** [October 13, 2023, 12:50pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/7 "2023-10-13T12:50:44Z")
Hi @maheshtare, I would suggest you to use “SQLLoader” connector and you can use SQL queries to merge /join the csv files upon aggregation. For your reference, [https://documentation.sailpoint.com/connectors/sql\_loader/help/](https://documentation.sailpoint.com/connectors/sql_loader/help/) ---
**Author:** ![maheshtare](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@maheshtare](https://developer.sailpoint.com/discuss/u/maheshtare)\ **Post date:** [October 13, 2023, 3:22pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/8 "2023-10-13T15:22:25Z")
Thanks Krishna for the solution, for now will go with SQL Loader ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [December 12, 2023, 3:23pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-merge-two-files/19117/9 "2023-12-12T15:23:16Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.