Bringing in data from another column if blank

[beneldridge]

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

[tresesco]

Try like:

Load

          [Column B],

          If( Len(Trim([Column A]))=0, [Column B], [Column A])   as [Column A]

[beneldridge]

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

[MindaugasBacius]

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:

[Anonymous]

Hi Ben,

As per mindaugasbacius solution you can achieve this thing in back-end as well as at front-end with given expression. !