Help with DATA Load

[arusanah]

I am getting data for Product table in csv file. I don't have Category field in Data source.  I am trying to generate category field in script as :

table A:

     id,

     county,

     region,

     'Electronics ' as [ Category Type]    // Inscript Field

From

ASD*.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Concatenate

Load  id,

     county,

     region,

     'Books ' as [ Category Type]    // Inscript Field

From

ASD*.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

But it doubles my data . which results incorrect count . any help will be highly appreciated

[sunny_talwar]

The same data is Electronics and Books? Not sure what you are trying to do?

[arusanah]

data is in following Format:

count of books | count Of electronic

I have to show 3 text boxes  on Dashboard .

1) Total sales which is count of Book + Electronics

2) Total electronics Sold

3) Total books Sold

they want to have functionality for ist text box to see only Book or only Electronics based on product Category Type.

thatz why I wanted to create inscript field

[sunny_talwar]

But how would you distinguish between the two outside of QlikView? You somehow need to distinguish between the two right? what is that distinguishing thing or things?

[maksim_senin]

Hi,

It's very strange approach to data modeling. Your data are doublicated because the script loads them twice from the same source. Moreover, it is not clear how you're planing to group them by [Category Type] if its values are the same for each line in each load... I suppose the category should come from the source or at least calculated somehow by some formula.

Please think out your data model first.

Best regards,

Maxim