Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

use two colour inline tables

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,

1 Solution

Accepted Solutions
sunny_talwar

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

];

View solution in original post

4 Replies
sunny_talwar

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
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
joeybird
Creator III
Creator III
Author

Your just Awesome, thank you x

sunny_talwar

Awesome, I am glad I was able to help