Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
We do an extract of SAP to get all items with their current status at the time of the extract. We than use that file to manage workload therefore employees are using this extraction as their worklist for the week. I want to know if it is possible to merge a specific column from their worklist to the next oervall extract. For example:
Both files have unique ID # associated to each transactions therefore is it possible to use this to merge a column named notes to the next full extract we have?
Solved! Go to Solution.
Don't bring in the original Notes column. Either delete it or select the other columns.
Then merge your file in and keep the Notes column from that.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingDon't bring in the original Notes column. Either delete it or select the other columns.
Then merge your file in and keep the Notes column from that.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting