Need to fill a new column based on row data

Wed, 28 Sep 2016 03:44:18 GMT

Hi All,

I need to convert the table 01 to table 02. Pease let me know if you have any suggestions. I tried to use FOR loop but failed. Would really appreciate if anyone could assist me asap. Thanks, Hansika

Re: Need to fill a new column based on row data

vishsaggi — Wed, 28 Sep 2016 16:49:27 GMT

Try this?

LOAD Time,

Resource,

RowNo() AS RowNum,

IF(Len(Period) = 0, Peek('Period'), Period) AS Period;

LOAD Time,

IF(Subfield(Resource,':',1) = 'Period', '', Resource) AS Resource,

RowNo() AS RowNum,

IF(Len(Time)>0, '', Resource) AS Period;

LOAD * INLINE [

Resource, Time

Period:7/30/2016-8/05/2016,

A,8

B,8

Period:9/30/2016-11/05/2016

A,8

B,8

C,8

];

topic Re: Need to fill a new column based on row data in QlikView

Need to fill a new column based on row data

Re: Need to fill a new column based on row data