topic Data loading problem in QlikView

Data loading problem

Wed, 09 Dec 2009 21:43:45 GMT

Hi,

I have a data loading problem from oracle. I have suche datas :

IDPERS TYPE YEAR

1 A 2003

1 C 2003

2 E 2001

2 A 2003

I want to have in QV :

1 AC 2003 (2 oracle lines becomes 1, concatenating the two types of the same year)

2 E 2001

2 A 2003

I can't find a way with the SQL request, do you have any idea in QV script ?

Thanks,

Wed, 09 Dec 2009 22:17:08 GMT

You could use the concat function:

LOAD
IDPERS,
YEAR,
CONCAT(TYPE,'') as TYPE
GROUP BY IDPERS, YEAR;
LOAD * INLINE [
IDPERS,TYPE,YEAR
1,A,2003
1,C,2003
2,E,2001
2,A,2003];

/Michael

Wed, 09 Dec 2009 22:29:04 GMT

I get an invalid expression with that solution, I don't think we can use concat in such case.

Wed, 09 Dec 2009 22:35:07 GMT

The above code works for me with your requested result in an empty application. Don't know why you get an error with it.

/Michael

Wed, 09 Dec 2009 23:15:18 GMT

Yes you are right it's ok now. Sorry and thanks.