Hi Guys,
I need your help , I'm trying to combine two records in a single record, I've tried without results to use a crosstab query.
e.g. : Following a sample of the table :
I need to combine the records in a single line like following:
The same tag AA-32x-A & AA-32x-B shalle be grouped in a single record, could you please help me? I've to use sql instructions?
I need your help , I'm trying to combine two records in a single record, I've tried without results to use a crosstab query.
e.g. : Following a sample of the table :
TAG | DESCRIPTION | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 4 |
AA-321A | TEST1 | 1 | 2 | 3 | 4 |
AA-321B | TEST2 | 5 | 6 | 7 | 8 |
AA-322A | TEST3 | 9 | 10 | 11 | 12 |
AA-322B | TEST4 | 13 | 14 | 15 | 16 |
I need to combine the records in a single line like following:
TAG | DESCRIPTION | FIELD 1 | FIELD 2 | FIELD 3 | FIELD 4 | TAG2 | DESCRIPTION2 | FIELD 5 | FIELD 6 | FIELD 7 | FIELD 8 |
AA-321A | TEST1 | 1 | 2 | 3 | 4 | AA-321B | TEST2 | 5 | 6 | 7 | 8 |
AA-322A | TEST3 | 9 | 10 | 11 | 12 | AA-322B | TEST4 | 13 | 14 | 15 | 16 |
The same tag AA-32x-A & AA-32x-B shalle be grouped in a single record, could you please help me? I've to use sql instructions?