Flat table

[#1]

Hi All

Hope someone can assist me. I am trying to write a Qlikview dashboard that takes a multi level bill of material and makes it a flat bill of material. The ERP System that is currently in use is Syspro. The is the current table structure.

I need to put all the levels in one table with all linked to a parent.

Hope I make sense. And thanks to all for the awesome Community!

[#2]

Please use the Left Join like below:

FLAT_TABLE:

LOAD LEVEL1,

          PARENT,

          LEV1_QTY

FROM LEV1_SOURE;

LEFT JOIN

LOAD LEVEL1, LEVEL2, LEV2_QTY FROM LEV2_SOURCE;

LEFT JOIN

LOAD LEVEL2, LEVEL3, LEV3_QTY FROM LEV3_SOURCE;

If your data sources are huge in size then use the ApplyMap (make sure the that values should be in distinct nature)

[#3]

Hi

Thanks for this, but how would I make the items in the tables appear in one list box.

Regards

Varshan

[Clever_Anjos]

Right Click, "Select Fields", choose which fields you want

[#5]

Hi Guys

Have a look at the list boxes on the attached picture. I have a level 1 and a level 2. What I need to for level 1 and level 2 to live on the same list box.

So all tiers of the Bill of material listed as a single tier.

Regards

V

[Clever_Anjos]

Create a field into your table using

Field1 & '/' & Field2

And mark "Show as a tree view"