Duplicate Data

[NavinReddy]

Dear All,

I have issue with Data

Actually i have 346 rows i have in Excel

But i created month field ,for that i loaded same data in 12 Times

Now i have 4152 rows i have

when i use count of rows 4152 its showing ,but actually 346 only

How can i Fix this issue please some one help me

I am attached QVW please find the QVW

Thanks In Advance

Niranjan

[Greg_Williams]

Do you have a loop in your script?

Please share the script.

[NavinReddy]

Hi,

open the Qvw you can find the Script

Regards,

Nianjan

[Gysbert_Wassenaar]

Please explain what you want 'fixed'.

[NavinReddy]

Hi Gysbert,

Actual data is 346,when i am using count its showing 4152

How can i fix this issue when i am using count it will show only 346

Best Regards,

Niranjan

[#6]

12*346 = 4152.

You are creating 346 records every time you concatenate

[Greg_Williams]

Yes. So it appears the fields (e.g. 1 as Month, 'Jan' as MonthDesc, etc.) are causing the replication in content to grow the records to 4152.

Have you considered employing:

1 - Preceding Load

2 - Mapping load/apply map to refer to appropriate month

Have you removed the explicit concatenation to see if Qlik will do this implicitly? If so, this can give you insight into how QV is treating your forced concatenation.

Greg !

[Gysbert_Wassenaar]

If you want a count of 342 then you need to load the data for only one month. You can't load 4152 records and get a record count of 342. Not in this universe at least. The math doesn't allow it.

[NavinReddy]

Yes exactly ,

i didnt removed ,dont know how can i do this

e.g. 1 as Month, 'Jan' as MonthDesc,

how can i do it with out loding 12 times

Best Regards,

Niranjan

[NavinReddy]

Yes , How can i break this

is there any way to with out using 12 times ,how can i create month field

Please guide me

Best Regards,

Niranjan