topic Re: Bringing in data from another column if blank in QlikView

Bringing in data from another column if blank

beneldridge — Wed, 25 Nov 2020 16:16:04 GMT

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

tresB — Mon, 29 Oct 2018 10:36:16 GMT

Try like:

Load

[Column B],

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

beneldridge — Mon, 29 Oct 2018 11:16:00 GMT

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 — Mon, 29 Oct 2018 11:21:56 GMT

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

(html, codepage is 1257, embedded labels, table is @1);

Result:

Anonymous — Tue, 30 Oct 2018 05:50:43 GMT

Hi Ben,

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