topic Re: Adding a record to a table in QlikView

Adding a record to a table

david_ze — Fri, 08 Mar 2013 20:38:57 GMT

Hi all,

I'll appreciate your help on a issue I have regarding adding a record to an existing table.

The table is looking like this:

Agent YearMonth Group ref_number

1 2013-01 A 6

2 2013-01 A 6

4 2013-01 A 6

5 2013-01 A 6

1 2013-01 B 9

2 2013-01 B 9

3 2013-01 B 9

4 2013-01 B 9

5 2013-01 B 9

1 2013-02 A 7

2 2013-02 A 7

3 2013-02 A 7

4 2013-02 A 7

5 2013-02 A 7

1 2013-02 B 2

2 2013-02 B 2

4 2013-02 B 2

5 2013-02 B 2

What I would like to do is to add a new record to all YearMonths which do not have agent data for each group.

I mean that to YearMonth 2013-01 you can see that for group A there is no data for 'Agent' number 3 and for 'YearMonth' 2013-02 you can see that we do not have data for 'Agent' 3 in group B.

At any case the Agent that will be missing will be always Agent number 3.

The new records that need to be added to the table should be as shown below:

3 2013-01 A 6

3 2013-02 B 2

I'll appreciate you prompt help on this.

Thanks in advanced

David

Re: Adding a record to a table

Fri, 08 Mar 2013 21:31:19 GMT

ORIGINAL_TABLENAME would be the above table name. concatenate(ORIGINAL_TABLENAME) LOAD * INLINE [ group name, company Group 1, Company A Group 1, Company B Group 2, Company C Group 3, Company D Group 3, Company ELOAD * INLINE [ Agent, YearMonth, Group, ref_number 3, 2013-01, A, 6 3, 2013-02, B, 2 ];

Re: Adding a record to a table

Fri, 08 Mar 2013 21:31:43 GMT

Re: Adding a record to a table

david_ze — Sat, 09 Mar 2013 09:52:42 GMT

I would like to add the records in an automatic way if it is recognized that those records are missing than the script should add them automaticlly.