Doubt creating flag when value doesn't exist

Wed, 25 Nov 2020 16:16:04 GMT

I have a table like this

I need a flag when value doesnt exist

i tried something like this

TemporalTC:

LOAD Country,

YearMonth ,

Value,

1 AS FLAG_HAY_TC

FROM

[..\number.xlsx]

(ooxml, embedded labels, table is Hoja1);

TC:

noconcatenate

Country

Value,

YearMonth,

IF(isnull(FLAG_HAY_TC),'1','0') AS FLAG_NO_TC

RESIDENT TemporalTC;

I tried also with if flag = 1 but it doesn't work

can you help me? maybe there is an example?

thank you

Re: Doubt creating flag when value doesn't exist

sunny_talwar — Fri, 30 Sep 2016 14:59:57 GMT

May be try this:

TemporalTC:

LOAD Country,

YearMonth ,

Value,

If(Len(Trim(Value)) > 0, 1, 0) as FLAG_HAY_TC

FROM

[..\number.xlsx]

(ooxml, embedded labels, table is Hoja1);