- This topic has 2 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
Hi, I am new to Biztalk. I have a flat file which I need to convert to a schema using the flat file wizard. Everything seems fine but the problem is that the flat file has a column header as the first line.
For eg.
Name Age Country
Sam 24 US
Pam 35 UK
How do I tackle this? I am sure I am missing something when creating the schemas. Also is there some property that I can set in Pipeline disassembler for this?
Please advise. Help will be appreciated.
-
Hi,
It might be not a good idea however this how i will handle it.
Since header values are fixed and happen only once, I will create a seperate record for header.
In this case I will have 2 records level. 1. HeaderTitles and 2. Records(its childern elements Name,Age,Country) . So I use the HeaderTitle record as a filter. Since you dont need this titles, you can use Name as an identifier to find out the header.
Let me know if i miss anything here.
Siva
-
Thanks Siva for the reply. I found another way of doing it after some looking around.
We can create 2 schemas:
(1) Header – This will have one string element type, “Name Age Country”. (This is the column header)
(2) Body – This will be the actual data records. This will have 3 elements, the name, age & the country as repeating records.
In the pipeline disassembler, there is a property where we can decide whether we want to include the header info or not in the final message. We can just disable this.
Please let me know if this sounds correct.
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.