topic rebuild table with unique records in QlikView

rebuild table with unique records

lorenzo_gibbo — Mon, 01 Jul 2013 15:23:44 GMT

HI all, I have a problem perhaps trivial, but I can not come out.

Forgive the title, but I did not know how to explain.

I have some particular set of data, I try to exemplifyto the maximum with the example below

ART	MATERIAL	IDENTIFIER	COLOR1	COLOR2	COLOR3
BENJY		0	RED	YELLOW	BLUE
BENJY	IRON	1	A	B	C
BENJY	PLASTIC	2	A	D	E

In this case the item BENJY is produced in the sale colors red yellow and blue but with materials of different colors.

For which, the article BENJY IRON color A, corresponds to BENJY RED, the article BENJY PLASTIC color E corresponds to BENJY BLU.

Where the identifier is 0 then the columns of the colors are selling colors. Where is different from 0 are the production colors.

I must therefore be able to upload via script a table that can give me the exact uniqueness of an article, material, production color, sale color; something like:

ART	MATERIAL	SALE COLOR	PRODUCTION COLOR
BENJY	IRON	RED	A
BENJY	IRON	YELLOW	B
BENJY	IRON	BLUE	C
BENJY	PLASTIC	RED	A
BENJY	PLASTIC	YELLOW	D
BENJY	PLASTIC	BLUE	E

Someone can give me some help?

thank you very much

Re: rebuild table with unique records

Mon, 01 Jul 2013 16:02:41 GMT

I think you will have to use the cross table option in the File Wizard Option when importing your source file and then you'll have to filter the records that have a 0 in the IDENTIFIER.

Then you'll have to create a mapping table that allows you to map the correct SALES COLOR for the ART - PRODUCTION COLOR combination. And map those values to your final table. Enclosed you can find an example.

Hope it helps!

Re: rebuild table with unique records

lorenzo_gibbo — Tue, 02 Jul 2013 08:04:59 GMT

I didn't know the mapping statement. Thanks!