Skip to main content
Question

combining and transposing multiple excel files

  • February 20, 2018
  • 7 replies
  • 14 views
S

I have multiple csv files that i need to combine. Table structure looks like below. I want the output to look like Table 3 and 4. I have tried to used to the columns to rows transpose but the input tables are not fixed and can change with new lines added etc, so not exactly sure how to do this

Table 1

LineAtt1Att21X 502X 493X 334X 895X 906X 45

Table 2

LineAtt1Att21Y 232Y 143Y 514Y 785Y 346Y 78

Table 3

Line123456Att1 (Table1)XXXXXXAtt1 (Table2)YYYYYY

Table 4

Line123456Att2(Table1)504933899045Att2(Table2)231451783478

@takashi

7 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • fmelizardSafer
  • Safer
  • February 20, 2018

Hi @sobanmughal,

Can I suggest that you take a look at @sander's fantastic and helpful AttributeTransposer customer transformer. You can read up on what it's designed to do and how it works here - https://hub.safe.com/transformers/attributetransposer - Make sure that you read the 'Notes' section.

S
  • sobanmughal
  • Author
  • February 20, 2018
fmelizard wrote:

Hi @sobanmughal,

Can I suggest that you take a look at @sander's fantastic and helpful AttributeTransposer customer transformer. You can read up on what it's designed to do and how it works here - https://hub.safe.com/transformers/attributetransposer - Make sure that you read the 'Notes' section.

Hi @MattAtSafe, the transformer is compatible with 2017 whereas i have 2016.

 

Also I have multiple tables to read from and not sure how to match the attributes, so they appear under the correct column as both tables will not have equivalent number of rows.

 

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • February 20, 2018

Hi,

I have tried an alternate method and written to csv instead of xls. Have a look, it needs to add the Line attribute...

Pratap

fme-transpose.zip

takashi
Evangelist
  • takashiEvangelist
  • February 20, 2018
What data format is the resulting tables (Table 3 and Table 4)? Excel, CSV, or else?

 

 

S
  • sobanmughal
  • Author
  • February 20, 2018
Excel or csv

 

 

takashi
Evangelist
  • takashiEvangelist
  • February 20, 2018
sobanmughal wrote:
Excel or csv

 

 

If CSV satisfies the requirement, I think @pratap's suggestion is very helpful.

 

S
  • sobanmughal
  • Author
  • February 20, 2018
pratap wrote:

Hi,

I have tried an alternate method and written to csv instead of xls. Have a look, it needs to add the Line attribute...

Pratap

fme-transpose.zip

Hi @pratap can you save it in FME2016 and send again.

 

Reply


Helpful Members This Week

Community Stats

31,521
Posts
119,503
Replies
39,150
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.