Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone help me with the coding to bring data in from another column if there is a blank cell in the column I am trying to fill?
Example would be how can I bring Jack and Jill into column A rather than me manually updating the download!
Thanks,
Ben
Column A | Column B |
---|---|
John | |
Jack | |
Joe | |
Jill |
Try like:
Load
[Column B],
If( Len(Trim([Column A]))=0, [Column B], [Column A]) as [Column A]
Hi Tresesco,
Thanks for replying, when I use this coding I am getting a error message:
Error in expression: ')' expected
Do you know why this is?
Thanks,
Ben
See the attachment.
There is the code:
tmp:
LOAD If(Len(Trim([Column A])) = 0, [Column B], [Column A]) as Modified,
[Column B],
[Column A]
FROM
[https://community.qlik.com/thread/318252]
(html, codepage is 1257, embedded labels, table is @1);
Result:
Hi Ben,
As per mindaugasbacius solution you can achieve this thing in back-end as well as at front-end with given expression. !