Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have two tables:
tab_1:
my_number
1
2
3
tab_2:
my_latter
A
B
C
I would like to creat new table as follows:
1A
2A
3A
1B
2B
3B
1C
2C
3C
will appreciate your help on the script i should use to do this.
thanks in advanced,
David
Hi David,
maybe like this?
tab_1:
LOAD * INLINE [
my_number
1
2
3
];
tab_2:
LOAD * INLINE [
my_latter
A
B
C
];
tmpResult:
NOCONCATENATE LOAD * resident tab_2;
inner join (tmpResult) LOAD *
resident tab_1;
Result:
LOAD my_number & my_latter as result resident tmpResult;
drop table tmpResult;
Hope this helps,
Stefan
Hi David,
maybe like this?
tab_1:
LOAD * INLINE [
my_number
1
2
3
];
tab_2:
LOAD * INLINE [
my_latter
A
B
C
];
tmpResult:
NOCONCATENATE LOAD * resident tab_2;
inner join (tmpResult) LOAD *
resident tab_1;
Result:
LOAD my_number & my_latter as result resident tmpResult;
drop table tmpResult;
Hope this helps,
Stefan
Hi David,
I suggest you have to load some thing like
tab_1:
LOAD * INLINE [
my_number
1
2
3
];
tab_2:
LOAD * INLINE [
my_latter
A
B
C
];
Temp:
load
my_latter as Letters
Resident tab_2;
join
Load
my_number as Numbers
Resident tab_1;
Main:
load
Letters&Numbers as NewField
Resident Temp;
Drop tables tab_1,tab_2;
Rgds
Anand
Thanks Stefan and Anand for the right answer.
David