Notifications
Clear all
Power Query
4
Posts
3
Users
0
Reactions
224
Views
Topic starter
I have a set of data and i wish to REPLACE some column(s) that contains values 1, 1, F adjacent to each other. whenever powerquery sees these set of three columns adjacent to each other containing 1,1, F respectively.I want it to replace the group of columns in that set of values to say 0, 0, * i know how to replace values with another value, buh i want just whenever the occurence of these values showed, to get it replaced in set. I have been strongly to resolve these for sometimes buh to no avail.
Click here and see the challenge: https://ibb.co/Bf3zGRn
Click here and see the challenge: https://ibb.co/Bf3zGRn
Posted : 26/05/2022 4:12 am
Add custom column if [exammth]=1 and [mth]=1 and [mthgrade]="F" then [exammth]=0 and [mth]=0 and [mthgrade]="*"
Posted : 26/05/2022 10:40 am
Hi Femco,
I couldn't get Jessica's proposed solution it to work, but the attached workbook contains a small scale example on a table with just 5 columns and 4 rows. I trust that you can identify the relevant steps that select the relevant columns and replaces the 1-1-F sequence with 0-0-*
If you don't succeed, you can perhaps upload a file with the exact structure as your real one, though without real names of real people.
Posted : 27/05/2022 8:21 am
Seeing Riny's solution I can visualize the problem better and see where I made my mistake, we're looking at 3 columns instead of 1 (which I knew but somehow my brain didn't fully register). Go with his solution. 🙂
Posted : 27/05/2022 10:48 am
