topic Re: Showing alternative data in App Development

Showing alternative data

iglou — Mon, 16 Jan 2023 09:41:22 GMT

Hi,

I have 2 tables of data with the following fields:

Table 1:

MayilVahanan — Mon, 16 Jan 2023 09:49:09 GMT

Try like below

Table1:

LOAD *,Category&Item as Key Inline [

Category, Item

1, A

1, B

1, C

2, A

2, C

2, D];

Table2:

LOAD *, if(not Exists(Key, Category&Alt_Item), Alt_Item) as FinalItem Inline [

Category, Alt_Item

1, A

1, B

1, D

1, E

2, B];

Drop field Key;

In Chart, use Category and FinalItem

iglou — Mon, 16 Jan 2023 10:43:58 GMT

Thanks! This works just fine!