topic Merge and format data after loading in QlikView

Merge and format data after loading

maxsugak — Sat, 16 Nov 2024 04:45:28 GMT

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?

Re: Merge and format data after loading

prieper — Tue, 15 Jan 2019 09:46:04 GMT

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

Re: Merge and format data after loading

uacg0009 — Tue, 15 Jan 2019 09:47:53 GMT

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

Re: Merge and format data after loading

maxsugak — Tue, 15 Jan 2019 10:09:51 GMT

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!

Re: Merge and format data after loading

maxsugak — Tue, 15 Jan 2019 10:11:14 GMT

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