Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey everyone,
I'm running into some issues with the current query I have and was hoping that someone might be able to point me in the right direction. As you can see in the picture 1, I am passing a value ("Column1") into the "URL" column. This URL gets the data from the api and loads the results into the "Record" column.
1.
Originally, I thought that if I clean the data for the "Table" in any one of these rows that it would apply all other tables in the "Record" column but it appears that the applied steps you'll see below only apply to the first table/record on the list.
2.
How can I iterate through the "Record" column (picture 1) and apply the same applied steps (picture 2) to each record?
Solved! Go to Solution.
Hi,
You need to create a custom column and formulate the expressions as per your specific requirements for the created tables (Record column). The choice of the formula depends on your objective. Please state your needs, and I might be able to assist you.
Hey Baghdadi,
I need to have each of the values in the "Record" column subjected to the following steps:
The steps above clean and format the data associated with the "Table" in the "Record" column however, I need them to apply to each "Table" in each row, not just the first one.
Hi,
You need to create a custom column and formulate the expressions as per your specific requirements for the created tables (Record column). The choice of the formula depends on your objective. Please state your needs, and I might be able to assist you.