Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
kicchu465
Contributor

Add more fields

I have a data like below

   

Manidnameextvaluememorynumberosconfig
HEWPKDDLMN380G8161281234WINDOWS32bit
HEWPKDDLMN381G9171281235WINDOWS32bit
HEWPKDDLMN382G10181281236WINDOWS32bit
HEWPKDDLMN383G11191281237WINDOWS32bit
HEWPKDDLMN384G12201281238WINDOWS32bit
HEWPKDDLMN385G13211281239WINDOWS32bit

I need output like below

in this after colon "this is windowsOS"  should be given to all the numbers  rest all to be concatenate the columns with spaces.

as a separate column

   

HEW PKD DLMN380 G8 16x128: this is windowsOS
HEW PKD DLMN381 G9 17x128: this is windowsOS

how can I achieve this?

1 Reply
vishsaggi
Esteemed Contributor III

Re: Add more fields

May be this?

LOAD *,

     Man& ' ' &id &' '& name & ' ' & ext & ' ' & value & 'x' &memory&':'& 'this is ' & Lower(os) &'OS' AS NewColumn  INLINE [

Man, id,      name,     ext, value, memory, number, os, config

HEW, PKD, DLMN380, G8,     16,     128, 1234, WINDOWS, 32bit

HEW, PKD, DLMN381, G9,     17, 128, 1235, WINDOWS, 32bit

HEW, PKD, DLMN382, G1,     18, 128, 1236, WINDOWS, 32bit

HEW, PKD, DLMN383, G11, 19, 128, 1237, WINDOWS, 32bit

HEW, PKD, DLMN384, G12, 20, 128, 1238, WINDOWS, 32bit

HEW, PKD, DLMN385, G13, 21, 128, 1239, WINDOWS, 32bit

];