Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi everyone,
i have a problem with replacing null values with content from other column. The scenerio is something like this. let say i have three columns A,B,C
A | B | C |
X | 10 | 10 |
X.1 | null | 10 |
X.2 | null | 10 |
Y | 11 | 11 |
Y.1 | null | 11 |
Y.2 | null | 11 |
C is my custom column created based on data from two columns A and B. please help with the query to construct above scenario.
Thanks,
Sivaaprataap.
Solved! Go to Solution.
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.
Hi Marcel,
Thanks for the help. It means a lot.
Regards,
Sivapratap
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |