Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try that:
LOAD
*,
RowNo() as Afkode;
LOAD * INLINE [
VareNr
31250
31251
31260
];
Hi,
Perhaps look at autonumber
Use Join function instead of Concatenate.
Join (Vare)
LOAD * INLINE [
VareNr, Afkode
31250, S
31251, S
31260, S
];
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
];
Try this:
Left Join (Vare)
LOAD * INLINE [
VareNr, Afkode
31250, S
31251, S
31260, S
];
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 ...;