Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Fill null cells with selected data

Hi,

 

I have to set a Class for each User & Channel in Power Query. I have created a Column that assign a class for the first Channel in pipeline (1487). Now, I'd like to set the same class to other Channels for the same user. I have tryed grouping the data, it was close, but I didn't managed to get the correct answer. Fill also didn't worked because the data in my table is not consecutive and we have no option to sort the data by 2 tables simultaneously . 

 

Here you have a data sample:

 

 

user_idstatuschannelCustom
64248COMPLETE1488null
64248COMPLETE1487Class2
64249COMPLETE1488null
64249COMPLETE1487Class1
64250COMPLETE1488null
64250COMPLETE1487Class3
64250COMPLETE1491null
64253COMPLETE1488null
64253COMPLETE1487Class4
64253COMPLETE1491null
64255COMPLETE1488null
64255COMPLETE1487Class2
64256COMPLETE1488null
64256COMPLETE1487Class5
64257COMPLETE1488null
64257COMPLETE1487Class2
64257COMPLETE1491null
64258COMPLETE1488null
64258COMPLETE1487Class1
64258COMPLETE1491null


I'd like to have the nulls populated with the data which is shown for Channel 1487 for each user.

user_idstatuschannelCustom
64248COMPLETE1488Class2
64248COMPLETE1487Class2
64249COMPLETE1488Class1
64249COMPLETE1487Class1
64250COMPLETE1488Class3
64250COMPLETE1487Class3
64250COMPLETE1491Class3
64253COMPLETE1488Class4
64253COMPLETE1487Class4
64253COMPLETE1491Class4
64255COMPLETE1488Class2
64255COMPLETE1487Class2
64256COMPLETE1488Class5
64256COMPLETE1487Class5
64257COMPLETE1488Class2
64257COMPLETE1487Class2
64257COMPLETE1491Class2
64258COMPLETE1488Class1
64258COMPLETE1487Class1
64258COMPLETE1491Class1

 

Any suggestions will be much appreciated.

 

3 Replies