Question

combining and transposing multiple excel files

8 years ago
Feb 20, 2018 12:11 AM UTC
7 replies
81 views

sobanmughal

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+22

fmelizard
Safer
8 years ago
Feb 20, 2018 12:25 AM UTC

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.

Upvote

S

sobanmughal
Author
8 years ago
Feb 20, 2018 1:43 AM UTC

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.