topic Re: Dummy ItemNr in QlikView

Dummy ItemNr

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

Hi,

Is there anybody who have a solution for creating a Dummy Afdkode for those VareNr listed below?

I've tried with this

Concatenate (Vare)

LOAD * INLINE [

VareNr, Afkode

31250, S

31251, S

31260, S

];

without any luck.

/Nong

Re: Dummy ItemNr

dapostolopoylos — Fri, 03 Aug 2018 14:12:33 GMT

Try that:

LOAD

RowNo() as Afkode;

LOAD * INLINE [

VareNr

31250

31251

31260

];

Re: Dummy ItemNr

Anonymous — Mon, 06 Aug 2018 04:49:27 GMT

Hi,

Perhaps look at autonumber

Re: Dummy ItemNr

sibin_jacob — Mon, 06 Aug 2018 04:58:43 GMT

Use Join function instead of Concatenate.

Join (Vare)

LOAD * INLINE [

VareNr, Afkode

31250, S

31251, S

31260, S

];

Re: Dummy ItemNr

pooja_prabhu_n — Mon, 06 Aug 2018 05:43:29 GMT

Hi,

Use join instead of Concatenate.

Use of concatenate will give data in the below format'

Join:

Vare:

LOAD * INLINE [

VareNr, Varekategorikodex

31250, FRAGT

31251, FRAGT

31260, FRAGT

];

Join (Vare)

LOAD * INLINE [

VareNr, Afkode

31250, S

31251, S

31260, S

];

Re: Dummy ItemNr

MindaugasBacius — Mon, 06 Aug 2018 05:43:33 GMT

Try this:

Left Join (Vare)

LOAD * INLINE [

VareNr, Afkode

31250, S

31251, S

31260, S

];

Re: Dummy ItemNr

sunny_talwar — Mon, 06 Aug 2018 11:22:40 GMT

Why don't you just do this if you want all null AfdKode to be converted to 'S'

LOAD VareNr,

If(Len(Trim(AfdKode)) = 0, 'S', AfdKode) as AfdKode,

VareKategoriKodeX,

VareKategoriKode

FROM ...;

If you want just VareNr 31250, 31251, 31260 to have S for AfdKode... then try this

LOAD VareNr,

If(Match(VareNr, 31250, 31251, 31260), 'S', AfdKode) as AfdKode,

VareKategoriKodeX,

VareKategoriKode

FROM ...;