I'm trying to populate column based on condition of different column that is data set.
Column_1 (can be 1,2,3)
Column_2 (if Column_1 == 1 then populate XZ)
Any ideas? Tried
if field('Column 1') == '1' then from_dataset('Sample') == XZ else ZZ but it's not working...