How to add new field

[anya]

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

[prieper]

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

[anya]

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

thanks a lot

[prieper]

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

[anya]

thank you