Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
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.