Hi,
I'm creating a BizTalk solution to process one purchase order.
customer,orderno,orddate,prodcode,proddesc,proddesc2,qty,price,deliverydt,delivery1
"700 KIDMAN WAY",66109,"03/03/15","CTV834","CTV834 GOSSIPS WHITE Cask Dry","4x5L 29313748009606",1200.0000,0.0000,"16/03/15","700 KIDMAN WAY"
"700 KIDMAN WAY",66109,"03/03/15","","**** run 18083 ****","",0.0000,0.0000,"03/03/15","700 KIDMAN WAY"
"700 KIDMAN WAY",66109,"03/03/15","CTV835","CTV835 GOSSIPS RED Cask Dry","4x5L 29313748009590",1200.0000,0.0000,"16/03/15","700 KIDMAN WAY"
"700 KIDMAN WAY",66109,"03/03/15","","**** run 18084 ****","",0.0000,0.0000,"03/03/15","700 KIDMAN WAY"
I want only alternate lines(1, 3.. etc) to get mapped and create XML file.
second line (4th line and so on) is invalid since there is no product code available.
So, the output XML file should contain only those lines having product code, in the same time line number should be proper.
Can we do it using BizTalk map or do we need to use csharp code?
Please help.
Thanks
Haris