Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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

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!
Highlighted
maxsugak
New Contributor

Re: Merge and format data after loading

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