Commenting out in a Cross Table

[#1]

I have multiple tables with 1 or 2 fields in common that i need to all link, however i get a synthetic key or loop everytime i reload. I tried to make a key to fix this, but since some of my tables are cross tables i dont think i can comment out the main, named field to do that - in this case "Month_Ref". Any suggestions?

Ex.

Table1:

Crosstable (Month_Ref, Forecast, 2)

Material,

Plant,

Month 1,

Month 2,

Month 3

Table 2:

Crosstable (Month_Ref, Shipments, 2)

Material,

Store#,

Month1,

Month2,

Month3

CalendarTable:

Month_Ref

MasterTable:

Material

Really appreciate the help!

Parrish

[#2]

Another note to add would be the the CalendarTable: Month_Ref also has fields that would link to Month_Ref in the other tables to then show date as text depending on the particular month number (Month1, Month2, Month3), or month date in actual date format, etc. So, with this being said, i do not believe that i should rename the Month1, Month2, and Month3 fields as it may jeopardize my Calendar.

[Anonymous]

hello,

I wait help you, try this

Table1:

Crosstable (Month_Ref, Forecast, 2)

Material,

Plant,

Month 1,

Month 2,

Month 3

Table 2:

Crosstable (Month_Ref, Shipments, 2)

Material,

Store#,

Month1,

Month2,

Month3

Table1:

LOAD AutoNumber(Material&'_'&Month_Ref) as Id_Tabla,

           Material,

           Plant,

           Forecast,

           Month_Ref

Resident Table1_tmp1;

DROP Table Table1_tmp1;

KeyTable:

LOAD Distinct Id_Tabla,

          Material,

          Month_Ref

Resident Table1;

DROP Field Material,

          Month_Ref From Table1;

Table2:

LOAD AutoNumber(Material&'_'&Month_Ref) as Id_Tabla,

          Material,

           Store#,

           Shipments,

           Month_Ref

Resident Table2_tmp1;

DROP Table Table2_tmp1;

Concatenate(KeyTable)

LOAD Distinct Id_Tabla,

          Material,

          Month_Ref

Resident Table2;

DROP Field Material,

          Month_Ref From Table2;

[Gysbert_Wassenaar]

You could simply concatenate the two tables. Or you could create a link table using the Qlikview Components library. See this discussion.