use two colour inline tables

[joeybird]

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,

[sunny_talwar · Accepted solution]

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

];

[jonathandienst]

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.

[joeybird]

Your just Awesome, thank you x

[sunny_talwar]

Awesome, I am glad I was able to help