Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
1. I have two tables, let's call them Table1 and Table2. Table1 has ProdID field and Table2 has ProdIDex field. ProdIDex contains only products I want to exclude from ProdID when I create charts etc. The logic would be:
if prodID <> ProdIDex display ProdID
2. I also would like to be able to put a "button" titled "Display ProdIDex" which I could activate and deactivate. This button would then run the above instruction and either remove or display ProdIDex products on a chart etc. Is this possible at all?
Thanks in advance.
Hello,
You can try to join that Dex info into the original table. Then just filter with the noDex = 'Yes'. Without the filter you'll see everything.
Table1:
Load * Inline [
ProdID
1
2
3
4
5
6
];
Join Load * Inline [
ProdID, noDex_temp
2, 'No'
4, 'No'
6, 'No'
];
Final:
NoConcatenate
Load
ProdID,
If(noDex_temp='No',noDex_temp,'Yes') as noDex
Resident Table1;
Drop table Table1;
Regards,
Pena
Hello,
You can try to join that Dex info into the original table. Then just filter with the noDex = 'Yes'. Without the filter you'll see everything.
Table1:
Load * Inline [
ProdID
1
2
3
4
5
6
];
Join Load * Inline [
ProdID, noDex_temp
2, 'No'
4, 'No'
6, 'No'
];
Final:
NoConcatenate
Load
ProdID,
If(noDex_temp='No',noDex_temp,'Yes') as noDex
Resident Table1;
Drop table Table1;
Regards,
Pena
Should look like this:
Nice one, thank you. It works as expected.