Rename table with the Row Number

[Mikahel369]

Hi there,

here is the code that I should use as guidance for rename my "expanded table"

= #"Expanded Table.CdtTrfTxInf.RmtInf.Strd.RfrdDocInf.RfrdDocTp"{2}[Table.CdtTrfTxInf.InstrForCdtrAgt]

so the table CdtTrfTxInf.InstrForCdtrAgt should actually be renamed like this "InstrForCdtrAgt{2}" where the number two is taken from the row number where the expanded table it was.

Any help would be appreciated.

thx

[_AlexandreRM_]

Hello @Mikahel369 ,

As Yalan, I don't fully understand your problem.

Still, here is what I can say: you can't rename a table via Power Query (in the same way that you can't rename a step of a query using power query itself).

But, you have a very useful function called Expression.Evaluate (see documentation: https://learn.microsoft.com/fr-fr/powerquery-m/expression-evaluate), which allows you to convert a text in its Power Query result.

For example, if you have a table named MyTable1, if you put = Expression.Evaluate("MyTable1", #shared) in a new blank query, you will see your table appearing just like if you typed = MyTable1. (The #shared keyword is used to tell Power Query to use the whole file context to evaluate the expression).

Last words, your problem seems to be a XY problem, see https://xyproblem.info/ 😉

Hope this helps.

[v-yalanwu-msft]

Hi, @Mikahel369 ;

Sorry, I kind of don't quite understand what you mean, can you give an example of what you want to output?

 please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Solved: How to upload PBI in Community - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mikahel369]

Hi,

thank you fo the reply and thanks to @_AlexandreRM_  as well

I try to explain the matter, that in the mean time I solved because I made in a different way, but in any case the solution might help me for a possible next time, if there is any solution:

I attach a couple of screenshots that hopefully will clarify all this.

Through the Power Query Ive expanded a couple of tables that are inside a table, as per fig.1, and then those once expanded have been translated into 2 different tables, that later in the excell file I can see as 2 different sheets, 1 is for the first [table] in row 3 and then the second for the one in row 5.

So my need it was in link those cells to the respective sheets, that means to give a value that could help me in the association.

I hope is clear what i mean.

thanks again and sorry for a late answer