Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saniyask
Creator
Creator

How do i remove unwanted fields from my already loaded data

ChannelWeekDateStart TimeEnd TimeDescription
CAT1215/23/20152:00:002:11:34A
CAT1215/23/20152:00:002:25:39A
CAT1215/23/20152:14:492:19:58A
CAT1215/23/20152:23:082:25:39A
CAT1215/23/20152:25:392:39:58B
CAT1215/23/20152:25:392:55:54B
CAT1215/23/20152:43:432:47:03B
CAT1215/23/20152:51:022:55:54B
CAT1215/23/20152:57:543:12:08C
CAT1215/23/20152:57:543:27:49C
CAT1215/23/20153:15:533:19:23C
CAT1215/23/20153:23:033:27:49C
CAT1215/23/20153:27:493:34:35D
CAT1215/23/20153:27:493:57:39D
CAT1215/23/20153:38:203:44:49D
CAT1215/23/20153:48:293:57:39D
CAT1215/23/20153:59:394:05:58E
CAT1215/23/20153:59:394:28:53E
CAT1215/23/20154:09:234:15:12E
CAT1215/23/20154:18:324:28:53E

I have a above data where i want only second field of a particular 'description'. how will i be able to fetch only that part of data..??

1 Reply
Gysbert_Wassenaar

Create a new table and drop the original:

New:

LOAD * WHERE Counter =2;

LOAD

     Channel,

     Week,

     Date,

     [Start Time],

     [End Time],

     Description,

     autonumber([End Time], Description) as Counter

FROM

     Old

Order By

     Channel,

     Week,

     Description,

     Date,     

     [Start Time],

     [End Time]

;

Drop Table Old;


talk is cheap, supply exceeds demand