topic How to add new field in QlikView

How to add new field

anya — Fri, 11 Jan 2019 07:33:08 GMT

dear all, i have a table like this

no	product	amount
skincare
1	cosrx	2
2	l'oreal	2

how to process the data in qlik sense, so that it can display like this table .

no.	product	amount	type
1	cosrx	2	skincare
2	l'oreal	2	skincare

please help me with the formula. Or give a fair idea about how to achieve this.

thanks

Re: How to add new field

prieper — Mon, 14 Jan 2019 15:30:58 GMT

give it a try with a scriptsolution:

Data:
LOAD
  *,
  IF(LEN(TRIM(product)) = 0, no, Peek('type'))  AS type;
LOAD
  *
INLINE [no, product, amount
   skincare
   1, corsrx, 20
   2, loreal, 10
   abc
   3, asdlfk, 2
   2, asld, 10];

Data_clean:
NOCONCATENATE LOAD
  *
RESIDENT
  Data
WHERE
  LEN(TRIM(product));

DROP TABLE Data;

HTH Peter

Re: How to add new field

anya — Wed, 16 Jan 2019 09:00:48 GMT

How about if the table as above is in Text form?

thanks a lot

Re: How to add new field

prieper — Wed, 16 Jan 2019 08:54:26 GMT

just replace the INLINE-section with (wizard generated) corresponding load-sequence from Excel.

Re: How to add new field

anya — Wed, 16 Jan 2019 09:17:05 GMT

thank you