Rule based mapping in Flatten transformation

Question

Rule based mapping in Flatten transformation

Subashri Vasudevan 11,306 Volunteer Moderator

Hi,

Is there a way I can simplify renaming columns in flatten settings without adding each column manually? Like column patterns.

For example, in the below example, I want to write expression to rename columns by ignoring all hierarchical info (ex: goods.orders.shipped.orderitems) and just keep the last portion as column name. Can we write expressions to achieve this? Basically, a generic expression that would just get me the last part of hierarchical shape for all the available columns.

Please advise. TIA

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2022-08-25T05:16:00.817+00:00

Hello @Subashri Vasudevan ,

Just checking in to see if the below answer provided by @MarkKromer-MSFT helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer accepted by question author

0 additional answers

Your answer

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2022-08-25T05:16:00.817+00:00

Hello @Subashri Vasudevan ,

Just checking in to see if the below answer provided by @MarkKromer-MSFT helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

MarkKromer-MSFT 5,231 Microsoft Employee Moderator

You will have to add a Select transformation after the Flatten and use patterns there to rename the columns

Subashri Vasudevan 11,306 Reputation points Volunteer Moderator

2022-08-23T07:41:14.253+00:00

Hi @MarkKromer-MSFT ,

Thanks for your reply. So, I can leave the mapping in flatten but do it on a select transformation right?

Thanks
MarkKromer-MSFT 5,231 Reputation points Microsoft Employee Moderator

2022-08-23T07:41:56.53+00:00

correct

Share via

Rule based mapping in Flatten transformation

0 additional answers

Your answer