Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
a | b |
1 | 5 |
2 | 6 |
3 | 7 |
4 | 8 |
This is my data but I want output like two fileds are comes in one field like
c
1
2
3
4
5
6
7
8
May be load 2 times one for a and one more for b then replace it to c from a and c from b then JOIN each
You have to load this table two times then and make same field names
Source:
Load * inline
[
a, b
1, 5
2, 6
3, 7
4, 8
];
Noconcatenate
New:
Load
a
Resident Source;
Concatenate(New)
Load
b as a
Rssident Source;
My Bad please delete the main table also
Source:
Load * inline
[
a, b
1, 5
2, 6
3, 7
4, 8
];
Noconcatenate
New:
Load
a
Resident Source;
Concatenate(New)
Load
b as a
Resident Source;
Drop table Source;
Hi Can try,
Table_Temp:
LOAD * INLINE [
a, b
1, 5
2, 6
3, 7
4, 8
];
Table:
LOAD a as c
Resident Table_Temp;
LOAD b as c
Resident Table_Temp;
Drop Table Table_Temp;