Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What's the simplest way of doing this? Thank you in advance!
Table1:
Load * inline
[
A,B
1,'a'
1,'b'
1,'c'
2,'d'
3,'e'
3,'f'
];
Table2:
Load * inline
[
C,D
1,'g'
2,'h'
3,'i'
4,'j'
];
ResultTable:
Load * inline
[
E,F
1,'g a b c'
2,'h d'
3,'i e f'
4,'j'
];
Hi,
one solution might be:
Table1:
Load * inline
[
A,B
1,'a'
1,'b'
1,'c'
2,'d'
3,'e'
3,'f'
];
Table2:
Load * inline
[
C,D
1,'g'
2,'h'
3,'i'
4,'j'
];
NoConcatenate
tabTemp:
LOAD C as A,
D as B
Resident Table2;
Concatenate (tabTemp)
LOAD * Resident Table1;
ResultTable:
LOAD A as E,
Concat(B,' ', RecNo()) as F
Resident tabTemp
Group By A;
DROP Tables Table1, Table2, tabTemp;
hope this helps
regards
Marco
Hi,
one solution might be:
Table1:
Load * inline
[
A,B
1,'a'
1,'b'
1,'c'
2,'d'
3,'e'
3,'f'
];
Table2:
Load * inline
[
C,D
1,'g'
2,'h'
3,'i'
4,'j'
];
NoConcatenate
tabTemp:
LOAD C as A,
D as B
Resident Table2;
Concatenate (tabTemp)
LOAD * Resident Table1;
ResultTable:
LOAD A as E,
Concat(B,' ', RecNo()) as F
Resident tabTemp
Group By A;
DROP Tables Table1, Table2, tabTemp;
hope this helps
regards
Marco
Worked perfectly! Thank you so much!
You're welcome.
Nice to hear it helped
regards
Marco