topic use two colour inline tables in App Development

use two colour inline tables

joeybird — Mon, 14 Dec 2015 13:15:22 GMT

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,

Re: use two colour inline tables

sunny_talwar — Mon, 14 Dec 2015 13:19:55 GMT

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

];

Re: use two colour inline tables

jonathandienst — Mon, 14 Dec 2015 13:24:03 GMT

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.

Re: use two colour inline tables

joeybird — Mon, 14 Dec 2015 13:33:35 GMT

Your just Awesome, thank you x

Re: use two colour inline tables

sunny_talwar — Mon, 14 Dec 2015 13:49:37 GMT

Awesome, I am glad I was able to help