平面文件架构与不均匀的结构化平面文件 [英] Flat file schema with uneven structured flat file

问题描述

大家好，

我有一个如下的平面文件。

101 | 1234 | 0 | 0000002500 | 03/12/2017 | 43242 | 0000010271 | 23423 | 243242

201 | 0000002500 | 1 || 0 | re | ref-30-1100

202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000

203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000

101 | 1234 | 0 | 0000002500 | 03/12/2017 | 43242 | 0000010271 | 23423 | 243242

201 | 0000002500 | 1 || 0 | re | ref-30-1100

202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000

203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000

202 | 0000002500 | 1 | 1 | 03/31/2017 | 2.0000

203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000

101 | 1234 | 0 | 0000002500 | 03/12 / 2017 | 43242 | 0000010271 | 23423 | 243242

201 | 0000002500 | 1 || 0 | re | ref-30-1100

202 | 0000002500 | 1 | 1 | 03 /31/2017|2.0000

203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000

203 | 0000002500 | 1 | 1 | 1 | 100.0000 | 2.0000

依旧。

这里的事情是行开头，2不是固定的事。

任何人都可以帮我创建平面文件架构。

谢谢，

VJ。

解决方案

你好VJ

以下博文显示了如何实现这种情况 -

https://blogs.msdn.microsoft.com / biztalknotes / 2013/02/05 /平面文件-模式创造-与标签的标识符 - 内式输入平面文件重复的功能于一个随机时尚/

Hi All,

I have a flat file like below.

101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
101|1234|0|0000002500|03/12/2017|43242|0000010271|23423|243242
201|0000002500|1||0|re|ref-30-1100
202|0000002500|1|1|03/31/2017|2.0000
203|0000002500|1|1|1|100.0000|2.0000
203|0000002500|1|1|1|100.0000|2.0000

and so on.

Here thing is line start with 2 is not a fixed occurrence.

Can anyone help me to create flat file schema.

Thanks,

VJ.

解决方案

Hi VJ

The below blog post shows how you can achieve this scenario-

https://blogs.msdn.microsoft.com/biztalknotes/2013/02/05/flat-file-schema-creation-with-tag-identifiers-in-the-input-flat-file-repeating-in-a-random-fashion/

这篇关于平面文件架构与不均匀的结构化平面文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！