Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

akumar_c
Contributor

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.

Community Browser