Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, please help me with the following question. I need to replace the text highlighted in yellow for only that cell marked in red. If I do a replace text it will also change the other exact words which I don't want to happen. Is it possible? Thanks
Solved! Go to Solution.
Hi,
In your Query Editor, add an index column and a custom column that looks for both the value you want to change and the ID that identifies the row.
Sub Category 2 = if ( [index] = 62 and [Sub Category] = "Mercadeo y Publicidad" ) then "Salario e Incentivos" else [Sub Category]
Remove Sub Category and rename Sub Category 2 to Sub Category.
Regards.
Hi,
In your Query Editor, add an index column and a custom column that looks for both the value you want to change and the ID that identifies the row.
Sub Category 2 = if ( [index] = 62 and [Sub Category] = "Mercadeo y Publicidad" ) then "Salario e Incentivos" else [Sub Category]
Remove Sub Category and rename Sub Category 2 to Sub Category.
Regards.
What data identifies that cell marked in red?
Is it the account AGUINALDO? Are there any other fields?
You could do something like:
Column = IF([Accounts] = "AGUINALDO" , SUBSTITUTE([Sub Category], "Salario...", "Mercadeo..."))
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |