Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two colour inline tables - is there a way of using two colour inline tables please?
I have
ColourDT:
LOAD * INLINE [
DT, R,G,B
'A', 204, 102, 119
'B', 102, 153, 204
'C', 51, 0, 255
AND
ColourDP:
LOAD * INLINE [
Dept, R,G,B
'Catering', 204, 102, 119
'HomeWare', 102, 153, 204
'Kids', 51, 0, 255
I keep getting a loop, or if I join one of the tables, one of the colour tables, e.g ColourDP , all column Dept colours turns black, where column DT works
please help,
Try this:
ColourDT:
LOAD * INLINE [
DT, R1,G1,B1
'A', 204, 102, 119
'B', 102, 153, 204
'C', 51, 0, 255
];
ColourDP:
LOAD * INLINE [
Dept, R2, G2, B2
'Catering', 204, 102, 119
'HomeWare', 102, 153, 204
'Kids', 51, 0, 255
];
Try this:
ColourDT:
LOAD * INLINE [
DT, R1,G1,B1
'A', 204, 102, 119
'B', 102, 153, 204
'C', 51, 0, 255
];
ColourDP:
LOAD * INLINE [
Dept, R2, G2, B2
'Catering', 204, 102, 119
'HomeWare', 102, 153, 204
'Kids', 51, 0, 255
];
I am not sure how you intend o use this information, but joining tables is essentially enriching or adding to the information on each row - for example joining something to table 1 on the field DT to provide additional information about DT.
I assume that this is not you intention - each row of ColourDP stands distinct from the rows in ColourDT. In this case, do noy join - rather concatenate the rows into a single colour table. Force the concatenation using the Concatenate key word.
Your just Awesome, thank you x
Awesome, I am glad I was able to help