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, 2022 in Others by Kithuzzz
• 38,010 points
1,236 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, 2022 by narikkadan
• 63,700 points

Related Questions In Others

0 votes
1 answer

How to read a dataframe from an excel sheet containing multiple tables?

Here is one option with scikit-image (highly inspired by ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
2,228 views
0 votes
0 answers

Copying values from multiple excel files to a single one with python

I want to replicate the values from ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
• 38,010 points
749 views
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
696 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, 2022 in Others by gaurav
• 23,260 points
1,411 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,740 points
972 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,090 points
895 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,090 points
4,167 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
3,950 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, 2022 in Others by narikkadan
• 63,700 points
613 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
• 63,700 points
2,050 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