Combine 2 variable in 1

[Anonymous]

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,

[rbecher · Accepted solution]

Then you have to use if() function:

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

- Ralf

[swuehl]

Maybe like this:

TMP:

LOAD  

     RangeMaxString(String1,String2) as Result

INLINE [

String1, String2

Hello, Hello

, Hallo

No, No

Yes,

];

[Anonymous]

Thanks,

It works!!!

[Anonymous]

Thanks,

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

Thanks again.