Scenario Help

[abhaysingh]

Hi all,

i have several product type in a table which are in field form(i.e. Prod1, Prod2, Prod3, Prod4, Prod5, Prod6 and so on).. i want to put it in single field called Product Category..How i can do this?

Thanks in Advance ...

[stigchel]

You can use a crosstable load, see example attached

[abhaysingh]

when i am using cross table my result set is getting increased..what to do in that case..

[stigchel]

What do you mean by result set getting increased, can you give an example demonstrating the problem?

[#5]

Hi Abhay

Can you please provide some practical sample or idea how do you required to implement the feature. you mean to say when you select the product it will display the all Product category is that what you required.

Thanks

[abhaysingh]

Hi Piet Hein,

i am simply counting the total product which are in numeric form.. and suppose total count in 20000 than after using cross table it is giving me 120000, this i mean to say my result set is increasing

[abhaysingh]

i have i column which contain the Total product count.. and product data is in form of multiple column like prod1 is column 1 and product 2 is column 2 and so on... i m using cross table with syntax.. Crosstable(Productname, data, Number).. but when i am simply doing count of Total Product..it is giving me 120000 intead of 2000

[stigchel]

Try with

=Count(DISTINCT Productname)

[jonathandienst]

Well that's correct and expected. The Crosstable load will give one row per value. If you have a 1000 rows with 6 values on each row and you crosstable that, each source row will result in 6 target rows, so you will get 6000 rows.

Crosstable is unpacking the data, although the table has more rows, it is much more efficient.

HTH

Jonathan