Dummy ItemNr

[Anonymous]

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

[dapostolopoylos]

Try that:

LOAD

     *,

     RowNo() as Afkode;

LOAD * INLINE [

VareNr

31250

31251

31260

];

[Anonymous]

Hi,

Perhaps look at autonumber

[sibin_jacob]

Use Join function instead of Concatenate.

Join (Vare)

LOAD * INLINE [

VareNr, Afkode

31250,  S

31251,  S

31260,  S

];

[pooja_prabhu_n]

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

];

[MindaugasBacius]

Try this:

Left Join (Vare)

LOAD * INLINE [

VareNr, Afkode

31250,  S

31251,  S

31260,  S

];

[sunny_talwar]

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 ...;