Service Desk

Hi Bhanu Sir,

We need to merge two different files and combine it into final ERP upload file.
The user is provided an option to select the device, input file1 and input file2.
Data from both the files to be merged and output file need to be generated.

Input File 1 is in Excel Format and the Input File 2 is in .txt Format.

The Output is to be generated(.txt format) by merging both these input files.
The Unique field in both file is "Society Deposit No."

Only the Fields mentioned in the e Records for which the "Society Deposit No" is matched in both the input files are to be displayed in the generated Output File.

Please display a new value for the dropdown field "Select Device" in the File Upload Screen named as "Koppal Pigmy Format".

Kindly refer to the attached Files

1) Pigmy Device File-Koppal PACS (Input 1).xlsx - Sample input File 1

2)00001271812D(Input-2).txt -- Sam-le input file 2

3)Koppal Device File Merge coversion Structure.txt -- (Set of Rules and the list of Specific Fields from the 2 input files that are to be displayed in the output file )

4)00001271812u(Output File).txt -- (Sample output File)

5)Output-Pigmy on 18-12-2024.jpeg -- (Sample Reference Image from the Intellect Application on uploading the Output file in their system).