Forum Discussion
Solved
Override/Edit a Single Cell
I have a data set that pulls in a long text ID that translates to a project name. I normally would replace values on the ID to the Project name and that worked in most cases. However I have some one ...
I struggled through this and couldn't get it to work. I however was able to fix it using a conditional column. The value I needed was in another column so using the custom conditional column I was able to say if it matches this unique ID then grab from that other column.
Yes, you'd add a Replace Values transformation step to your query and then modify as needed similar to the example I gave.
I struggled through this and couldn't get it to work. I however was able to fix it using a conditional column. The value I needed was in another column so using the custom conditional column I was able to say if it matches this unique ID then grab from that other column.