Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Load Data from TXT with multiple delimeters

Hi,

If you will open my attached notepad :

CARDTYPEID###NAME###CARDTYPE2GRAPHICSBITMAP###CARDTYPE2BROWSERBITMAP###TABLENAME###CLASS###DESCRIPTION###PORTSTARTNUMBER###SLOTSTARTNUMBER###CARDSIZE###CRITICALFLAG###POWERSUPPLIED###POWERUSED###POWERUNITS###COOLINGSUPPLIED###COOLINGUSED###COOLINGUNITS###ISVISIBLE###LABEL###

These are my field. Start from CARDTYPEID### and End with LEVEL###. CARDTYPEID### is unique key and It start with some number. LEVEL### is End of the Column - 0$$$.

Some of the data is null so \N is available, At data entry time some raw is blank so it start with new row. Now I want to identify a single row which has been start with Unique Key and end with 0$$$. Due to blank row I am not able to Identify the same. I have removed the delimeter. But Some row is coming blank and for that new row is coming with different field.

So Help on this. Also find the attached QVW and TXT file.

0 Replies