CODEWITHSUNDEEP
xsdbiztalkflat-file
LastTribunal
LastTribunal

Reputation: 1

BizTalk Flat File Schema Wizard empty field issue

I have a repeating record that looks like this:

12345               joe, smith            123 main st            apt 12      65
14345               jane, doe             323 south st           1st fl      44
12745               bob, adams            623 high rd                        33

How do I configure the wizard to deal with records like Bob, that have address2 field blank. Is there even a way to do this in the FFSW?
Note that these columns are not tab delimited, so I can only use "Relative Position"

Upvotes: 1

Views: 648

Answers (1)

Nigel B
Nigel B

Reputation: 3597

As long as your records are fixed length there should be no problem doing this using the flat file wizard. You can specify field lengths. follow the wizard as detailed below:

enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here

Upvotes: 2

Related Questions