Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
maxsugak
New Contributor

Merge and format data after loading

Hi!

I'm loading data in Sense using  basic script and have 2 issues:

1. I need to merge columns. For example in Excel it looks like "ABC" and "DEF" columns, and after loading I need the only column "ABCDEF".  I'm trying to do the next:

LOAD
Column1 & Column2 as Column3

But I get double data in a table like this "ABCDEFDEF".  Could anyboby explain me my mistake?

 

2. After loading I need to delete some special symbols in a string. For example make "ABC!!DEF" to "ABCDEF" removing those exclamation marks. 

Any suggestions please? 

 

 

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Merge and format data after loading

Hi Maxsugak,

For the first one:

I think normally you will get "ABCDEF" value in column3, if possible, it's better to share a small sample of your data, so I can check the reason that why you get "ABCDEFDEF" in column3.

For the second question:

You can use PurgeChar() function, in your example, like : = PurgeChar(Column3,'!')

Aiolos Zhao

View solution in original post

4 Replies
prieper
Honored Contributor II

Re: Merge and format data after loading

wrong group - should be QS.
for 1. please post an example. If content in Column1 is "ABC" and in Column2 "DEF" then the result of Column1 & Column2 should be "ABCDEF".
You may use REPLACE, e.g.
REPLACE(MyString, '!', '')
or load only characters with
KEEPCHAR(MyString, 'abcdefgh.....ABCDEFG...1234567890')

HTH Peter
Partner
Partner

Re: Merge and format data after loading

Hi Maxsugak,

For the first one:

I think normally you will get "ABCDEF" value in column3, if possible, it's better to share a small sample of your data, so I can check the reason that why you get "ABCDEFDEF" in column3.

For the second question:

You can use PurgeChar() function, in your example, like : = PurgeChar(Column3,'!')

Aiolos Zhao

View solution in original post

Highlighted
maxsugak
New Contributor

Re: Merge and format data after loading

Thanks a lot!

I will try to fix it on my own firstly. Such a challange 🙂
I just wanted to make sure I use correct operator ... & ... as ....

Thanks!
maxsugak
New Contributor

Re: Merge and format data after loading

Sorry about the group, my fault.
Thansk for your reply!