Data loading problem

[#1]

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,

[#2 · Accepted solution]

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

[#3]

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

[#4]

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

[#5]

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