Pentaho excel input from multiple sheets to textfile

0 votes
I have an Excel workbook containing departmental figures on various sheets. I want to read all the data from every sheet and send it to rows in a text file with the first column being the sheet name (dept name). Can this be done? I only get one of the specified sheets when I set up an Excel Input and add them to the import, and I'm not sure how to add the sheet name as a row in the output text file. The only difference between any two sheets is the sheet name.

The output text file should be like this:

Sheetname1;Sheet1:A1;Sheet1:B1

Sheetname1;Sheet1:A2;Sheet1:B2

Sheetname2;Sheet1:A1;Sheet1:B1

Sheetname2;Sheet1:A2;Sheet1:B2

etc.
Oct 20 in Others by Kithuzzz
• 20,660 points
76 views

1 answer to this question.

0 votes

It's possible to use numerous Excel inputs with essentially the same settings, with the exception of the sheet name and data start.

You can adjust the metadata and column order so they exactly align with one another once each input phase is completed. Then, simply perform a union with any step. I like to accomplish it with a Dummy.

Example:

Pentaho Multiple inputs, Dummy as a "Append Streams"

answered Oct 20 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
• 3,190 points
256 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
529 views
0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
306 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
6,168 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
397 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,371 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,836 views
0 votes
1 answer

Excel: How to merge two columns into one (from different sheets or separated columns)

This equation is completely adjustable. Your two ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
76 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

A combination of IF(), ISNUMBER(SEARCH()), and OR() ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
59 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP