topic Re: Combine 2 variable in 1 in QlikView

Combine 2 variable in 1

Anonymous — Mon, 12 Aug 2013 20:59:46 GMT

Hi all,

Very easy question. How combine 2 variable in 1 in load?

Var1	Var2
0
	4
7
9
2
6
	8
4
9
	10
3
7
5

Thanks,

Re: Combine 2 variable in 1

Mon, 12 Aug 2013 21:05:44 GMT

If you want to combine the columns, you could do this:

Var 1 & '' & Var 2 as Var12

You could do this on import or add it as a dimension afterwards.

Best,

Matt

Re: Combine 2 variable in 1

rbecher — Mon, 12 Aug 2013 21:07:47 GMT

Hi Vladimir,

if this is a two column source and either Var1 or Var2 is null or empty you can just concatenate by "&" and then convert to number:

LOAD num(num#(Var1 & Var2)) as Result ...;

- Ralf

Re: Combine 2 variable in 1

Anonymous — Tue, 13 Aug 2013 14:33:29 GMT

Thanks guys for your help.

For some records I have duplicate

ID	Var1	Var2	Result
8028000027015020	10		10
8028000027015160	8		8
8028000027015450		4	4
8028000027015590	1	1	11
8028000027015600	1	1	11
8028000027016060	10	10	1010
8028000027016210
8028000027017560	10		10
8028000027017700		0	0
8028000027017780
8028000027017840	5	5

I need only 1 number. Use condition If? or maybe you more logical function?

Thanks,

Re: Combine 2 variable in 1

rbecher — Tue, 13 Aug 2013 14:44:42 GMT

Better try alt() function:

LOAD alt(Var1,Var2) as Result ...;

- Ralf

Re: Combine 2 variable in 1

Anonymous — Tue, 13 Aug 2013 18:08:49 GMT

Thanks Ralf,

It works!!!

Alt doesn't work with string variable?

alt("Var1_number","Var2_number") as "Result1", works

alt("Var3_string","Var4_string") as "Result2", doesn't work

it keeps only last variable data.

Re: Combine 2 variable in 1

rbecher — Tue, 13 Aug 2013 19:24:00 GMT

Of course alt() function is for numeric data, please take a look into the help.

Therefor, this should work:

LOAD alt(num#(Val1), num#(Val2)) as Result ..

- Ralf

Re: Combine 2 variable in 1

Anonymous — Tue, 13 Aug 2013 19:27:52 GMT

Ok, thanks.

It didn't work

Re: Combine 2 variable in 1

rbecher — Tue, 13 Aug 2013 20:11:42 GMT

Please see attached example with your data..

Re: Combine 2 variable in 1

Anonymous — Wed, 14 Aug 2013 14:14:19 GMT

Thanks Ralf for sharing the file.

I don't have problem with alt function for numeric variable.

I need to do the same for string variable.

Thanks again.

Re: Combine 2 variable in 1

rbecher — Wed, 14 Aug 2013 14:24:16 GMT

Then you have to use if() function:

if(len(trim(Var1))=0, Var2, Var1)

- Ralf

Re: Combine 2 variable in 1

swuehl — Wed, 14 Aug 2013 15:26:18 GMT

Maybe like this:

TMP:

LOAD

RangeMaxString(String1,String2) as Result

INLINE [

String1, String2

Hello, Hello

, Hallo

No, No

Yes,

];

Re: Combine 2 variable in 1

Anonymous — Wed, 14 Aug 2013 16:59:10 GMT

Thanks,

It works!!!

Re: Combine 2 variable in 1

Anonymous — Wed, 14 Aug 2013 17:00:02 GMT

Thanks,

I didn't check it, but you always give right idea and issue.

Thanks again.