Flat File Format Change in BizTalk Server

venkatasiva yadav 231

Hi ,

I am getting Flat File from Utility services which have both Water and Electricity bills with Tax, like below format

FlatFile:

BillNumber,BillDate,BillAmount,AccountNumber,AccountName,E_MeterNumber,E_Meterreading Date,E_CurrentMeterreading,E_ConsumptionUnits,E_UnitRate,E_Bill,W_ConsumptionUnits,E_PrvMeterreadingDate,E_PrvMeterReading,W_MeterNumber,W_ConsumptionUnits,W_UnitRate,W_CurrentMeterReading,W_MeterreadingDate,W_Bill,W_ConsumptionUnits,W_PrvMeterreadingDate,W_PrvMeterReading,E_TotalTax,W_TotalTax.

now i want to Make it like below structure for integration with another system from BizTalk sever , please help me to format the above text to below format .

Root

Header (Record)

BillNumber
BillDate
BillAmount
AccountNumber
AccountName

Body (Record)

Electricity (record)
   E_MeterNumber
   E_Meterreading_Date
   E_CurrentMeterreading
   E_ConsumptionUnits 
   E_UnitRate,E_Bill 
   E_ConsumptionUnits 
   E_PrvMeterreadingDate 
   E_PrvMeterReading,
Water (record)
   W_MeterNumber
   W_ConsumptionUnits
   W_UnitRate,
   W_CurrentMeterReading,
   W_MeterreadingDate,
   W_Bill,
   W_ConsumptionUnits,
   W_PrvMeterreadingDate,
   W_PrvMeterReading
Elec_TAX (record)
   E_TotalTax
Water_Tax(Record)
   W_TotalTax

Colin Dijkgraaf 1,346 Reputation points

2021-04-30T00:22:54.413+00:00

So what are you having trouble with?
venkatasiva yadav 231 Reputation points

2021-04-30T14:58:59.03+00:00

i don't know , how to format from text file to xml structure.
Colin Dijkgraaf 1,346 Reputation points

2021-05-02T22:04:31.14+00:00

You create a Flat File Schema in BizTalk that matches the incoming structure and have a flat file disassembler on the Receive Pipeline.

Share via

Flat File Format Change in BizTalk Server