Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Flat file data source from multiple files
venkatmadh
hi
all
i am using Birt 3.7 Version
i have to Flat File
one File contains Header(All Headers as one Column),Another File Contains Header-Values (As one Row comma seperated Values).
now i excepted result like Header = Headervalue
please any one help me on this,
I attached my Header.txt file and HeaderValue.txt file
and also i attached Result.txt file
This very urgent Requirement please look at once
:blink: :blink:
Find more posts tagged with
Comments
mwilliams
So, there's a variable number of columns in the HeaderValue flat file? There aren't a fixed number of values? Or are there? Let me know.
venkatmadh
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="100623" data-time="1337268696" data-date="17 May 2012 - 08:31 AM"><p>
So, there's a variable number of columns in the HeaderValue flat file? There aren't a fixed number of values? Or are there? Let me know.<br /></p></blockquote>
<br />
<br />
<br />
<br />
hi<br />
williams<br />
<br />
Thank you very much for quick response<br />
<br />
<br />
Both cases are there,<br />
<br />
<br />
i.e<br />
<br />
i have two cases,<br />
<br />
1) Fixed number of columns <br />
<br />
2) variable number of Columns<br />
<br />
<br />
please give me one example on that
mwilliams
This should help get you started with one way to do it. The header.txt file is read in using a flat file dataSource and the other is read in with a scripted dataSource and they're joined together in the same scripted dataSource. Let me know if you have issues.