https://community.qlik.com/t5/Talend-Studio/Mapping-txt-in-talend/m-p/2211581#M9547 <DIV class="votecell post-layout--left"> <DIV class="js-voting-container grid fd-column ai-stretch gs4 fc-black-200"> <DIV class="js-favorite-count mt8"> <SPAN>I need to map the first 2 rows from a .txt file into a database in talend. Right now mapping csv files work, however since I don't have headers in the .txt file how can I map it. </SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>Lets say my txt file has data as follows:&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>apple&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>banana&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>23321</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>32132321</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>3212</SPAN> </DIV> <DIV class="js-favorite-count mt8"> I want to take apple and banana (rows 1 and 2 ) each time and map them to the table in db. This should also be automatic, thats why im currently using filewatcher. </DIV> <DIV class="js-favorite-count mt8"> The image shows what I did so far <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2019-03-03 at 5.35.43 PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2iO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156419i6A2C7C6B8492747A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2iO.png" alt="0683p000009M2iO.png" /></span></SPAN> </DIV> </DIV> </DIV> Sat, 16 Nov 2024 06:26:46 GMT Anonymous 2024-11-16T06:26:46Z https://community.qlik.com/t5/Talend-Studio/Mapping-txt-in-talend/m-p/2211581#M9547 <DIV class="votecell post-layout--left"> <DIV class="js-voting-container grid fd-column ai-stretch gs4 fc-black-200"> <DIV class="js-favorite-count mt8"> <SPAN>I need to map the first 2 rows from a .txt file into a database in talend. Right now mapping csv files work, however since I don't have headers in the .txt file how can I map it. </SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>Lets say my txt file has data as follows:&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>apple&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>banana&nbsp;</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>23321</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>32132321</SPAN> </DIV> <DIV class="js-favorite-count mt8"> <SPAN>3212</SPAN> </DIV> <DIV class="js-favorite-count mt8"> I want to take apple and banana (rows 1 and 2 ) each time and map them to the table in db. This should also be automatic, thats why im currently using filewatcher. </DIV> <DIV class="js-favorite-count mt8"> The image shows what I did so far <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2019-03-03 at 5.35.43 PM.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2iO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156419i6A2C7C6B8492747A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2iO.png" alt="0683p000009M2iO.png" /></span></SPAN> </DIV> </DIV> </DIV> Sat, 16 Nov 2024 06:26:46 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-txt-in-talend/m-p/2211581#M9547 Anonymous 2024-11-16T06:26:46Z https://community.qlik.com/t5/Talend-Studio/Mapping-txt-in-talend/m-p/2211582#M9548 <P>Will your database table change for each iteration?<BR /><BR />If no, just use Limit as 2 and header 0.<BR />Schema should be same as table is same.<BR /><BR /></P> Sun, 03 Mar 2019 18:21:51 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-txt-in-talend/m-p/2211582#M9548 akumar2301 2019-03-03T18:21:51Z