Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to replace characters in all fields with blank/null?

Hi All,

I have below sample data, I want to remove these charaters '' to blank/null while loading data. Please advise. Can we do by one script being applied to all columns?

TypeDoc NoDateDoc Type
A34765
B1/24/2015INV
C500369
A
B
C

Thanks,

SAK

5 Replies
Highlighted

This should work:

LOAD PurgeChar(Type, '') as Type,

          PurgeChar([Doc No], '') as [Doc No],

          PurgeChar(Date, '') as Date,

          PurgeChar([Doc Type], '') as [Doc Type]

Resident/FROM


HTH

Best,

Sunny

         

Highlighted

Tried it with your sample data:

Table:

LOAD PurgeChar(Type, '') as Type,

          PurgeChar([Doc No], '') as [Doc No],

          PurgeChar(Date, '') as Date,

          PurgeChar([Doc Type], '') as [Doc Type];

LOAD Type,

     [Doc No],

     Date,

     [Doc Type]

FROM

[https://community.qlik.com/thread/163361]

(html, codepage is 1252, embedded labels, table is @1);

Output looks like this:

output.PNG

Highlighted
MVP
MVP

How did you load this data? It looks like you specified the wrong character set or code page... Maybe if you changed that you wouldn't get the strange characters...

Highlighted
Not applicable

Yep, you are right.

First I got data downloaded to excel from HTML webpage and hence got these characters.

But then I directly loaded into qlikview, so now it's all fine

Highlighted
Not applicable

The labels are now coming in first row of data loaded even though I have made it embedded labels.

IS there any way to add header lines in embedded labels while loading data from HTML wewebpage?