Add more fields

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

I have a data like below

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?

Re: Add more fields

vishsaggi — Fri, 27 Oct 2017 16:46:29 GMT

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

];