Forum Discussion
Dynamic name extraction.
Hi Anonymous
Profiling is easy you can reference this table and add extra column like below.
The transformation could be done in a similar way however I would advise creating a function for transformations.
Another option would be doing all the transformation in dataflows.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz actually after we get tables from the dataflow we are doing a data profiling transformations on all of them so that we can get information about their columns and than appending them. How will I do this tranformations then.
Table.Profile(Table 1)
Hi Anonymous
Profiling is easy you can reference this table and add extra column like below.
The transformation could be done in a similar way however I would advise creating a function for transformations.
Another option would be doing all the transformation in dataflows.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz Yes. I did try that. Still the expand step is taking like forever. I dont know whats wrong with it.
ThankYou very much though. I appreciate your help:smileyhappy:.
Regards,
Chahat
Anonymous I had a similar issue, the easiest thing to do is to load all the tables to SQL Server and then combine them and adding a simple query to get the table names appended and then feed to Power BI.
