Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below table with fields VID, LID and Category and Subcategory.
Table1:
VID | LID | category | SubCategory |
V12 | L09 | HC | L |
V36 | L32 | HC | D |
V65 | HC | D | |
M87 | L8 | HC | L |
M90 | L5 | HC | C |
C63 | L8 | HC | L |
J18 | L9 | HC | M |
P27 | HC | D |
Table2:
LID | Llocation | Category |
L9555034 | China | HC |
L9645384 | China | HC |
L9712371 | India | HC |
L9712383 | India | NA |
L9712395 | SL | NA |
L9712474 | USA | HC |
L9713337 | AFG | DA |
L9713349 | HK | JP |
L9713351 | SA | HC |
I want to create a chart which will have all fields of Table1 where SubCategory is either L or D.
1. Copy all rows from Table A |
2. Add LID's from Table B (Only when Category Is not HC) |
Like this?
Try this in Load Script;
Final1:
LOAD * where SubCategory='L'
OR SubCategory='C';
LOAD * INLINE
[VID, LID, category, SubCategory
V12, L09, HC, L
V36, L32, HC, D
V65, ,HC, D
M87, L8, HC, L
M90, L5, HC, C
C63, L8, HC, L
J18, L9, HC, M
P27, ,HC, D
];
Final2:
LOAD * where Category='NA' OR Category='DA' OR Category='JP' ;
LOAD * INLINE
[LID, Llocation, Category
L9555034, China, HC
L9645384, China, HC
L9712371, India, HC
L9712383, India, NA
L9712395, SL, NA
L9712474, USA, HC
L9713337, AFG, DA
L9713349,HK, JP
L9713351,SA, HC
];
Thanks,
Shekar!!