Q24
Hotspot
HOTSPOT
You have an API that returns more than 100 columns. The following is a sample of column names.
1. client_notified_timestamp
2. client_notified_source
3. client_notified_sourceid
4. client_notified_value
5. client_responded_timestamp
6. client_responded_source
7. client_responded_sourceid
8. client_responded_value
You plan to include only a subset of the returned columns. You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Select the correct area(s) on the image.