Data association issue

RaMa — Wed, 22 Dec 2021 15:27:40 GMT

I have 3 Tables

1. Sales - > Having Order#, Line#, SKU1, SKU2, Plant#, OrderQuantity - (consider SKU2 as substitute item for SKU1)

2. Item Master - > Mat#, SKU# (mapping is available for Mat1 to SKU1 and Mat2 to SKU2 in this table),

3. Inventory Table - > Mat#, Plant# , Avl Qty

Using Association without using script is there a way to view

Order # , SKU1, OrderQuantity, Avl Qty (for SKU1) , SKU2, Avl Qty (for SKU2)

Re: Data association issue

RaMa — Sat, 27 Apr 2019 02:25:11 GMT

The scenario is in Qliksense environment