Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi Guys,
i have files in csv in folder and want to get only headers for them.
In transform sample file i did example for csv where rows are null and i have only headers:
I created List but the list is delimeted by "," and i want to convert it somehow to records(rows).
My goal is to have table with 2 columns: TableName, ColumnName for each table in folder.
Can you please help?
Best,
Jacek
Solved! Go to Solution.
Keep it as List only. I believe you created list by following formula in sample file
=Record.ToList(_)
After this, delete all columns from your sample file except last one.
Now, you will have this result in your combined file
When you click double arrow then, you get option for Expand to new rows and you will get following result
Keep it as List only. I believe you created list by following formula in sample file
=Record.ToList(_)
After this, delete all columns from your sample file except last one.
Now, you will have this result in your combined file
When you click double arrow then, you get option for Expand to new rows and you will get following result
Thank you @Vijay_A_Verma It worked.
What doest it mean "_" within "(_)" ?
Can you please explain?
Best,
Jacek
_ means current row.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.