Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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