topic Re: Create a new table with a new key from an existent table in QlikView

Create a new table with a new key from an existent table

cristian_p_labra — Sat, 16 Nov 2024 21:26:06 GMT

Good day, pals!

I have a table like this

LOAD
id_company,
name_company,
tax_owed,
tax_paid,
type_company,
type_operation
FROM
..\..\taxes.xlsx

It looks so:

0001 Blue Co. 100 100 Good 01
0002 Yelow Co. 200 100 Bad 00
0003 Red Co. 150 50 Bad 01
0004 White Co. 200 100 Bad 01
0005 Black Co. 120 120 Good 00
0005 Green Co. 130 130 Good 00
0006 Pink Co. 125 25 Bad 00
0007 Silver Co. 180 90 Bad 00

I'd like to create 2 tables

Taxes:
0001 Blue Co. 100 100 1 01
0002 Yelow Co. 200 100 2 00
0003 Red Co. 150 50 2 01
0004 White Co. 200 100 2 01
0005 Black Co. 120 120 1 00
0005 Green Co. 130 130 1 00
0006 Pink Co. 125 25 2 00
0007 Silver Co. 180 90 2 00

Type:
1 Good
2 Bad

For this second table I had to create a sequencial id_field (a key)
I'm really beginner on QlickView, but soon I'll be colaborating, too.

Re: Create a new table with a new key from an existent table

bharathadde — Wed, 13 Feb 2019 22:24:47 GMT

Try this one, hope this is what you needed

A:
id_company,
name_company,
tax_owed,
tax_paid,
type_company,
type_operation
FROM
..\..\taxes.xlsx;

Qualify *;
UNQUALIFY id_company;

Good:
LOAD
*
Resident A
where type_company = 'Good';

Bad:
LOAD
*
Resident A
where type_company = 'Bad';

Re: Create a new table with a new key from an existent table

cristian_p_labra — Fri, 15 Feb 2019 10:44:24 GMT

Thank you very much. I'll try this.